In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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