community
cancel
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.

Meteoroid

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

 

Formula

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

 

 

Labels