Date Time Formation

Timo97

Hello everybody,

i have a strange data format for dates, it is looking like this 10-JAN-20 but of cause this dosent work with Alteryx DateTimeDiff(dt1,dt2,u) function.

Would be really nice if someone could help me to transform this into somethink that work.

Thanks a lot 

Timo 

atcodedog05

Hi @Timo97 

Here is how you can do it.

Formula:

DateTimeDiff(
DateTimeParse([Date 2],"%d-%b-%y"),
DateTimeParse([Date 1],"%d-%b-%y"),
"days")

Workflow:

Hope this helps : )

days diff.yxmd