Datediff function not working with date in string format

[ferha_jafri]

Hello Experts,

I am trying to evaluate no. of days between 2 dates which are in string format as "06/30/2120" and "06/30/2021". The result is coming as blank can anyone help.

[atcodedog05]

Hi @ferha_jafri 

Alteryx accepts only datetime format of yyyy-mm-dd rest other formats are considered as string. Please use datetimeparse() function to parse date to proper date format.

Hope this helps : )

[atcodedog05 · Accepted solution]

Hi @ferha_jafri 

You can use formula like below.

DateTimeDiff(
DateTimeParse([Date1],"%m/%d/%Y"),
DateTimeParse([Date2],"%m/%d/%Y"),"days")

Workflow:

Hope this helps : )

[ferha_jafri]

Thank you so much.

[atcodedog05]

Happy to help : ) @ferha_jafri 

Cheers and have a nice day!