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!
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
@mzsweetumz
Just play around with the formula. we can use also the DateTimeadd, to add 24 hours to the Admin Date then check.