Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Calculation between two dates with AM/PM

mboroto_89
8 - Asteroid

Hi, 

I want to calculate the difference in time(in minutes) between two dates. My dates are as attached

 

i want to see the total difference in minutes between  Completion_Time and Complete_Before.

 

If Completion_Time is after the  Complete_Before then return "Late"

if Completion_Time is before the  Complete_Before then return "Early"

 

The tricky part is with the AM/PM part.

10 REPLIES 10
AlexEntz
8 - Asteroid

I second the answer of Sapna Gupta.

 

@mboroto_89 If you want dive deeper into datetimefunctions, here is the documentation: https://help.alteryx.com/20221/designer/datetime-functions

Labels
Top Solution Authors