SOLVED
Date Difference
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
nicktekippe
8 - Asteroid
01-31-2024
11:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I need an Alteryx formula that will return the number of days between CREATED_DATE and COMPLETION_DATE. Both columns are Date data types. If the CREATED_DATE and COMPLETION_DATE are the same day the formula should return 0.
Below is a sample of the dataset
Solved! Go to Solution.
Labels:
- Labels:
- Data Investigation
- Date Time
- Developer
3 REPLIES 3
18 - Pollux
01-31-2024
11:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
DateTimeDiff([COMPLETION_DATE],[CREATED_DATE],"days")
However, you may have to figure out a way to deal with those null values!
18 - Pollux
01-31-2024
11:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@nicktekippe I saw the email that this was marked as a solution but I don't see the acceptance on the post. Can you mark the answer as a solution? Thank you in advance!
18 - Pollux
01-31-2024
11:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@nicktekippe I see it now - thank you!
