If Statement for date expiration


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!


In your {PRA Expired?} field:

      {PRA Expiration}

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


That worked perfectly! Thank you so much!