Datediff function not working with date in string format

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.

Preparation

Accepted answers

atcodedog05

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 : )

datediff.yxmd

All comments

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

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 : )

datediff.yxmd

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703