Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, how do i find the time interval between 2 columns, datecreated and dateconfirmed, and extract the minutes? Thanks.
Hi
Try like this
Edit:
Interval(DateConfirmed - DateCreated , 'mm')
Hi
Try like this
Edit:
Interval(DateConfirmed - DateCreated , 'mm')
The following expression will give a correct numeric value:
(dateconfirmed - datecreated) * 24 *60
An alternative is to keep the difference in days (an hour is then 1/24), but format it in minutes:
Interval(datecreated-dateconfirmed,'mm')
Note that the format code is case sensitive.
HIC
Hi,
if the two columns, datecreated and dateconfirmed are already formatted as timestamps, you can add the following expression:
time(num(datecreated)-num(dateconfirmed),'mm')
'MM' will give a month interval, 'mm' will give minute interval.
Hi James
Thanks for your reply. I didn't notice that.
Hi
Time() is quite different to Interval(). Time(value, 'mm') will format to display the minute number of the current time, while Interval(value, 'mm') will show the number of minutes in value.
Eg.
Time(1.55, 'mm') displays 12 (for a time of day of 13:12:00)
Interval(1.55, 'mm') displays 2232 (number of minutes in 1.55 days)
HTH
Jonathan