Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Problem in DateTimeDiff min function.


I am unable to produce correct results  here.


Here is my data. Both columns are datetime type.

Date12/03/2018  00:00:00 
Date21/03/2018 11:48:00 PM



DateTimeDiff(    [Date1]    ,     [Date2],'min'            )


Result: 732 ???? 


Correct resulst is 12 minutes.




732 is the difference be 11:48:00 AM and midnight


Can you check the dates are in the format YYYY-MM-DD HH:MM:SS with hours in 24 hour format?


If they are in a different format you will need to parse the strings before using the datetimediff function