8 Replies Latest reply on Dec 1, 2010 1:24 PM by RonCates

    Field status change from active to expired by current date

    cMuller

      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!