Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
Start 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