Calculate time difference between dates

[mzsweetumz]

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!

[BrandonB]

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

[binu_acs]

@mzsweetumz similar to @BrandonB suggestion

[Qiu]

@mzsweetumz 
Just play around with the formula. we can use also the DateTimeadd, to add 24 hours to the Admin Date then check.