If EndDates has past current date make inactive (Solved)
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