trailing 12 month indicator

[ntudev]

Hi Everyone,

How would i add a trailing 12month indicator, starting today for example? I just want it to say yes if the date is within the last 12 months. I attached a sample excel sheet.

[gautiergodard · Accepted solution]

hey @ntudev 

Here is one way to do it!

if [Date] >= datetimeadd(DateTimeToday(),-12,'months') then "Yes"
else "No"
endif

[ntudev]

what would be a formula if instead of just today i want to put '2022-07-30'?

[ntudev]

what would be a formula if instead of just today i want to put '2022-07-30'?

[gautiergodard]

@ntudev sorry for the late response.

If you wanted to make it a static date you could use this:

if [Date] >= datetimeadd(todate('2022-07-30'),-12,'months') then "Yes"
else "No"
endif