Jump to content

Multi dates


This topic is 5767 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I am making a Filemaker program that will be used for my work. What we do is set appointments for home finial advisors to attend. There is 1 field that is the date called "Apptdate", then there is another 3 fields for Rescheduals. These are called "Apptdate2", "Apptdate3", "Apptdate4".

I have made another field called "latestappt" and what i want to do is to get Filemaker to search the 4 boxes. If "Apptdate4" is empty, copy "Apptdate3" to "latestappt", unless "Apptdate3" is empty, then copy "Apptdate2" to "latestappt" unless that is empty, then copy "Apptdate" to "latestappt".

Now i was going to make "latestappt" a calculation, however i wasnt having much luck with the else statesments in there. i know the command line

If ( Appdate4 ; Appdate4 ; Last(Appdate3) )

will paste "Appdate3" into the box "Lastappt".

i know the lines would heve to be something like this

If ( Appdate4 ; Appdate4 ; Last(Appdate3) )

else

If ( Appdate3 ; Appdate3 ; Last(Appdate2) )

else

If ( Appdate2 ; Appdate2 ; Last(Appdate) )

end if

But i get the error "This function Cannot be found".

Anyone know what i am doing wrong?

Edited by Guest
Link to comment
Share on other sites

  • Newbies

Hi

"else" isn't a function to use for calculations !

Use this calc:

Case(

not IsEmpty(Appdate4);Appdate4;

not IsEmpty(Appdate3);Appdate3;

not IsEmpty(Appdate2);Appdate2;

Appdate

)

Head bang... I was playing around with IsEmpty but didnt think to add the Not in front. Thanks so much for the help.

Link to comment
Share on other sites

This topic is 5767 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.