Good afternoon!
I'd like to create a field that would simply show if a date within the record is within the past year.
We already have a field "Date Received" for each record. I'd like to have a field that can quickly show if that date is within the past 365 days. I'm guessing the best way would be a formula field that would display either a "Yes/No" (or a check or something) if the "Date Received" value is on or before one year from the current day.
Anyone able to help craft that formula? Or is there a better way to do this?
Formula to show if a date is within the past year
+6+7Good Afternoon!
Something like this shoudl do what you are looking for:
IF(DATETIME_DIFF(NOW(), {Date Received}, 'days')>365, "OLD", "NEW")
This will return "OLD" if it is greater than 365 days or "NEW" if it is newer. You can change those out for whatever emoji or word you would like.
All the best.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.