Hi Team,
Can some one please help me to resolve the below formula.
I just wanted to add one customized date and add 30 days to it.
IF [Status]="closed" then "closed" elseif [Status]="On Hold" then "On Hold" elseif [AnticipatedWinDate] <"06/01/2019" then "Past Due" elseif [AnticipatedWinDate]<=DateTimeAdd([ 06/28/2019 ],+30,"days") then "0 to 30 Days" else ">30"
ENDIF
Somewhere i am not getting the expression right "=DateTimeAdd([ 06/28/2019 ],+30,"days")"
Regards,
Ranjan
Solved! Go to Solution.
Hi @RanjanKT Alteryx like dates formats in the form of YYYY-MM-DD so think you need to do a conversion of your data in order to add 30 days like below
Thanks for the response to be more clear on the request.
There is no inbuilt date field in the data.
Date which i need to insert. Does it work if i add YYYY-MM-DD format?
Regards,
Ranjan
Hi @RanjanKT Yes that would work as well like below.