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!
Page 1 / 1
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.
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.
That worked perfectly! Thank you so much!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.