IF Formula with Date condition

[RanjanKT]

Hi,

Can some one help me correcting the below formula.

For some reason i am getting the out put only

Closed

Pastdue

>90

if [Stage]="Closed" then "Closed" elseif [AnticipatedWinDate]<"28-06-2019" then "Pastdue" elseif [AnticipatedWinDate]<=DateTimeAdd("2019-06-28",+30,"days") then "0-30" elseif [AnticipatedWinDate]<=DateTimeAdd("2019-06-28",+60,"days") then "31-60" elseif [AnticipatedWinDate]<=DateTimeAdd("2019-06-28",+90,"days") then "61-90" else ">90"
Endif

The date is in the below format

[Thableaus · Accepted solution]

Hi,

Your First clause has a date out of date format. Correct the Format to yyyy-mm-dd

if [Stage]="Closed" then "Closed" elseif [AnticipatedWinDate]<"2019-06-28" then "Pastdue" elseif [AnticipatedWinDate]<=DateTimeAdd("2019-06-28",+30,"days") then "0-30" elseif [AnticipatedWinDate]<=DateTimeAdd("2019-06-28",+60,"days") then "31-60" elseif [AnticipatedWinDate]<=DateTimeAdd("2019-06-28",+90,"days") then "61-90" else ">90"
Endif