JavaScript must be installed and enabled to use these boards.
Your browser appears to have JavaScript disabled or does not support JavaScript. Please refer to your browser's help file to determine how to enable JavaScript.
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.
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
