If Cover_to_Date is the expiration date then you have Lapsed and In-Forced reversed or you can change the > sign to <.
You if statement states if 2/31/13 is greater than the 2/9/13 then its Lapsed.
Also under storage options click Do not store - recalculate as need.
and make sure that Cover_to_Date is a field of type Date and not a field of type Text.
Thanks for this Mr/Ms Chamblee, but am still struggling.
Am using UK date format and it reads thus: If(Get(CurrentDate)>CoverFrom;"lapsed";"in-force")
But each time simply returns a '?'
Wondered if you had further advice?!
The field CoverFrom must be of type date and may not be empty.
The calculation field where this formula lives must be unstored and of type text.
Then this should work.
If there still are problems, tell us your FMPro version and platform.