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 December 5, 200520 yr by Guest

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

)

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.