If statement with date formula

[Brian_Krahling]

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!

[Jeremy_Oglesby]

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.

[Brian_Krahling]

Jeremy_Oglesby:

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

That worked perfectly! Thank you so much!