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.
Solved! Go to Solution.
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