Change a value into a Date and calculate DateTimeDiff

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

Preparation

Accepted answers

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

Best,

Yalmar

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

thank you Yalmar

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