This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am unable to produce correct results here.
Here is my data. Both columns are datetime type.
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