Comparing a date with today's date for a calculation

[exposbabe]

Read everything I could about the current date and how dates work, and not sure if I can do this.

Each order is delivered monthly. The order is for a specified time period, usually one year.

I want to designate the records as "active" or "inactive".
To do that, I need to compare the expiry date with today's date.

Expiry date > today's date = "active"
Expiry date < or = today's date = "inactive".


How do I do this? Help! Thanks

 

[JeanW]

FileMaker is storing dates as a numeric value for days elapsed from 1/1/0.

You can use a Case() for this, together with the Get(CurrentDate) function in an unstored calc field, result text, something along these lines:

Case(
expireDate <= Get(CurrentDate);"Inactive";"Active"
)

 

[exposbabe]

Beautiful. Tks.