need help with datetimetoday formula

wanting to mirror my excel formula if(date<(TODAY()-395), "No","Yes") . Attempted this formula but receive a red squiggle before the first DateTime. IIf DateTimeToday([Cal/Mth/Yr])<DateTimeToday()[Cal/Mth/Yr]-395 then "No" else "Yes" ENDIF

Cal/Mth/Yr - 2022-03-01

Tips and Tricks

Accepted answers

All comments

SPetrie

DateTimeToday doesnt use arguments, its just todays date.

To get a year prior, you use datetimeadd but give it a negative number in units of years.

Assuming you have a column named date and it is a date format, you can use a formula like this.

IIF([Date] < DateTimeAdd(DateTimeToday(),-1,"years"),"Yes","no")

If [Date] < DateTimeAdd(DateTimeToday(),-1,"years") then "Yes" else "no" endif

Youre example was combining both formats which will also give you headaches.

binu_acs

@joffner another method

joffner

Thank you

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703