DATETIME_DIFF within an IF function

[Mathieu_Preau]

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?

[Brittany_Claudi]

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