Change a value into a Date and calculate DateTimeDiff

[msantoso]

Dear All

I need to calculate the duration in months between two dates 

but I have an issue: the date format I received is not yyy.mm.dd, but dd.mm.yyyy and is a string format. 

how can I turn this string date into a date with the correct Alteryx format? 

thank you for your help

Myriam

[yalmar_m]

Dear @msantoso,

You might want to use the datetime tool (in the parse folder), and afterwards calculate the difference in months using a formula tool.

Best,

Yalmar

[msantoso]

thank you Yalmar

could you please be more specific? I am a very beginner and do not know what is the parse folder

[yalmar_m]

Hi @msantoso,

According to my interpretation of your post,this is the solution you want.

Best,

Yalmar

[msantoso]

thank you Yalmar, 

I did find the Datetime and tried but I did not find the subtile difference between dd.MM.yyyy and dd.mm.yyyy!!

thank you for your help

have a good day!

[yalmar_m]

Hi @msantoso

the m stands for minute whereas the M is representing month.

Best,
Yalmar

[msantoso]

good to know! thanks again

[yalmar_m · Accepted solution]

Dear @msantoso

Is this the solution for your question? Please mark the right answer as a solution!

Best,

Yalmar