Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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