Field status change from active to expired by current date
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)
Can somebody please help me out? Thanks!