Finding the numbers of days from two dates

[binsell]

Hi All, I have two dates that I'm trying to find the number of days. I have converted my dates using the 'DateTime' tool and then the formula: DateTimeDiff([Actual End],[Actual Start], "days")

Example: Actual Start Date 11/09/2023 Actual End Date 15/09/2024 - Calculate number of days which would be 370

First issue is the date is not in the format that I wanted. I selected dd/MM/yyyy and wanted to come out as 11/09/2023 but instead is showing as 2023-09-11 (not the end of the world but wondering why)

Second issue that my formula is showing a 'TRUE' response, rather than the number of days. 

Any help would be much appreciated as very new to Alteryx! 

[binuacs · Accepted solution]

@binsell use the DateTimeParse() formula to convert it into ISO date format, then with the help of DateTimeDiff() function you can find the result

[binsell]

Thank you so much! This has worked :)