Datediff from string - excel format

Baz123

Hi,

I have two date fields that I need to find the days between :

Start	End
30-Jun-2022	18-Aug-2022
10-Aug-2022	18-Aug-2022

You can see the format above that is in the raw data, which Alteryx reads as a string.

I used :

DateTimeDiff(
DateTimeParse([Start],"%d/%m/%Y"),
DateTimeParse([End],"%d/%m/%Y"),"days")

But this throws the error, as the data is in the wrong format as expected :

ConvError: Formula (5): DATETIMEPARSE: Cannot convert "18-Aug-2022" to a date/time with format "%d/%m/%Y" and language "English": Expected a number for Month: 'Aug-2022'

Any help on tweaking the formula so it can calculate days would be great.

Thanks.

gautiergodard

Hello,

Please see attached solution! 

**Please like this post and mark this thread as resolved if this provided the answer to your question**

datediff.yxmd