Help

Creating an IF that checks if current date is greater/less than date field

3433 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Jay_Lee
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m trying to create a formula field with an IF conditional that checks if the current date is greater/less than 365 days from a date that’s specified on a field date I have.

For example, I have an “Order” field that’s set as a date field.
I want to check to see if the “Order” field is greater than or less 365 days from the current date. If the date is greater, I want it to output “Long”. If shorter, I want it to output "Short.)

Any help would be greatly appreciated!

2 Replies 2
Tuur
10 - Mercury
10 - Mercury

Hi there! Try this…

IF(DATETIME_DIFF(TODAY(), Order, 'days') > 365, 'LONG', 'SHORT')
Jay_Lee
5 - Automation Enthusiast
5 - Automation Enthusiast

@Tuur Beautiful. Thanks much!