If Statement for date expiration


#1

Hello.
I have a date field called “PRA Expiration”, and I would like to use an if statement to give me Yes, if the date is past the current date, and no if it is not in a field called “PRA Expired?”. Can someone help? Thank you!


#2

In your {PRA Expired?} field:

IF(
   IS_AFTER(
      TODAY(),
      {PRA Expiration}
   ),
   "Yes",
   "No"
)

If Today’s date is AFTER the PRA Expiration date, then “Yes”, the record is expired. Otherwise, “No”, the record is not expired.


#3

That worked perfectly! Thank you so much!