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
Solved! Go to Solution.