Help

DATETIME_DIFF within an IF function

Topic Labels: Formulas
Solved
Jump to Solution
8303 10
cancel
Showing results for 
Search instead for 
Did you mean: 
Mathieu_Preau
4 - Data Explorer
4 - Data Explorer

Hi there,

I need to calculate the difference between the {Date} and today in days, and display “todo” or nothing if the number of days is >1.

I tried this but I keep having errors :

IF(DATETIME_DIFF({Date}, TODAY(), ‘days’)>1),“To do”, " ")

Any ideas?

10 Replies 10
Brittany_Claudi
5 - Automation Enthusiast
5 - Automation Enthusiast

@Justin_Barrett the first one worked beautifully. Thank you!!