AnsweredAssumed Answered

Field status change from active to expired by current date

Question asked by cMuller on May 26, 2010
Latest reply on Dec 1, 2010 by RonCates

Title

Field status change from active to expired by current date

Post

Hello and thank you for help in advance. I am using FMP 10 on Mac OSX (and a noob)

 

I have a table of records for different events. The events have different dates, start dates and end dates. Some of these events are over a few days and will have a date and an end date.

 

Basically I need a field to display as "Active" if the event is in the future or currently going on. Else I need the field to display as "Expired".

 

However, some of the events will only be one day and only have a date field and no end date.

 

 

As of now I have this set up as a calculation field as follows (My syntax is also not working):

 

If ( DateEnd < Get ( CurrentDate ) ; "Expired"; status)
Else If ( DateEnd  ≥  Get ( CurrentDate ) ; "Active"; status)
Else If ( Date  <  Get ( CurrentDate ) ; "Expired"; status)
Else If ( Date  ≥  Get ( CurrentDate ) ; "Active"; status)
End If

 

Can somebody please help me out? Thanks!


Outcomes