Difference in minutes between 2 dates

[#1]

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

[MarcoWedel]

(Timestamp2-Timestamp1)*1440

[its_anandrjs]

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

[#4]

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