help defining caculation text from dates

[gwyster]

Hi, I am trying to define a calculation field that results in text. When another field, a date field, has nothing in it, the result would be "not vacant"

and if the date field was >= today the result would be "vacant". Can anyone assist me on this?

Thanks

Greg Young

[Fitch]

Case( IsEmpty( date field ), "not vacant", date field >= Status (CurrentDate), "vacant" )

[gwyster]

Tom,

You know I really appreciate you sharing your knowledge. Through several years of trial and error, I have created very useful applications for my business. I now know enough to realize more of what FM can do, but often lack the basic programming skills to execute it. Thanks for taking the time to get me past my stuck point.

Greg