Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Finding the numbers of days from two dates

binsell
8 - Asteroid

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! 

2 REPLIES 2
binuacs
21 - Polaris

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

image.png

binsell
8 - Asteroid

Thank you so much! This has worked :) 

Labels
Top Solution Authors