Help

Re: Formula to show if a date is within the past year

1473 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Hal_Atkins
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

1 Reply 1
Brian_Swanson
6 - Interface Innovator
6 - Interface Innovator

Good 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.