topic Difference in minutes between 2 dates in QlikView

Difference in minutes between 2 dates

Thu, 23 Oct 2014 11:42:47 GMT

Hey everyone,

I have date fields. for example : 03/10/2013 17:00:00

How can I calculate the difference between 2 date fields in minutes ?

Thanks for you help

Have a good day

Laura

Re: Difference in minutes between 2 dates

MarcoWedel — Thu, 23 Oct 2014 11:58:58 GMT

(Timestamp2-Timestamp1)*1440

Re: Difference in minutes between 2 dates

its_anandrjs — Thu, 23 Oct 2014 12:00:38 GMT

Use interval function i suggest like

Ex:-

Load

Interval( DateFieldA - DateFieldB, 'mm' ) as Difference

From Location;

other wise you can use Minute function Minute(DateField)

Regards

Anand

Re: Difference in minutes between 2 dates

Thu, 23 Oct 2014 14:11:44 GMT

Note that your suggestion for using Minute(DateField) will not work correctly as it only gives you the minute portion of an interval, so if the difference was 1 hour and 12 minutes, Minute (DateField) will return 12 minutes, not 72 minutes as you would want

Your Interval answer would work though