2 Replies Latest reply on Jan 18, 2015 7:39 PM by zeak.smith

    If EndDates has past current date make inactive (Solved)

    zeak.smith

      Title

      If EndDates has past current date make inactive (Solved)

      Post

      Hi I am a total noob at filemaker,

      i have a table that list members subscription, the subscriptions only last 12 month.

      what i am trying to create is a calculation that goes something like, default value is "Active" but if EndDate has past Get(CurrentDate) then mark field "Inactive"

      If anyone able to point me in the right direction to getting this done.

      Thanks in advance

      Zeak