Calculate time difference between dates
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
mzsweetumz
8 - Asteroid
‎09-12-2022
10:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I would like to create a new column to calculate with row has an admit date and discharge date of less than 24 hours.
Any help would be appreciated!
Thank you!
Labels:
- Labels:
- Date Time
3 REPLIES 3
Alteryx
‎09-12-2022
10:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
https://help.alteryx.com/20221/designer/datetime-functions
This is a very helpful link for datetime functions. You will be particularly interested in DateTimeDiff()
IF DateTimeDiff([Discharge Date], [Admit Date], "Hours") <24
THEN "Yes"
ELSE "No"
ENDIF
binuacs
21 - Polaris
‎09-12-2022
02:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
21 - Polaris
‎09-12-2022
04:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@mzsweetumz
Just play around with the formula. we can use also the DateTimeadd, to add 24 hours to the Admin Date then check.
