Hi all,
I have a date and time received :2019/01/21 02:05:00
and a date and time delivered: 2019/01/23 10:13:00
I need to know what is the difference in days, hours and minutes
Tried the datediff, days work out fine but hours is not correct
it can all be in one field or Days in one field and hours / min in a different field
my result is 2 Days, 8 hours and 0 min which is obviously not correct.
Any suggestions would be appreciated.
I have a date and time received :2019/01/21 02:05:00
and a date and time delivered: 2019/01/23 10:13:00
I need to know what is the difference in days, hours and minutes
Tried the datediff, days work out fine but hours is not correct
it can all be in one field or Days in one field and hours / min in a different field
my result is 2 Days, 8 hours and 0 min which is obviously not correct.
Any suggestions would be appreciated.