Finding the numbers of days from two dates
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
- Labels:
- Date Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binsell use the DateTimeParse() formula to convert it into ISO date format, then with the help of DateTimeDiff() function you can find the result
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much! This has worked :)
