Customized date plus 30 days

[RanjanKT]

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

[JosephSerpis]

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

[RanjanKT]

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

[JosephSerpis · Accepted solution]

Hi @RanjanKT Yes that would work as well like below.