Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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