Difference between two time stamp

[#1]

Hi all,

I need to find out the difference between two timestamp in minute.

E.g:- Date1 :-1/8/2013 20:55

         Date2:- 1/9/2013 29:55

Expected result:- (Date2- Date1) = 1380 min.

Kindly help me find out this.

Thanks ,

D J

[Sokkorn]

Hi,

Maybe you can try Interval(Date2-Date1,'mm')

Regards,

Sokkorn

[vivientexier]

=Interval(Date1 - Date2, 'mm')

Of course, you can use another format (example : 'D hh:mm')

[#4]

it's not working.

[vivientexier]

Ok, are you sure your date is really a date and not text. multiplie your Date field by one to be sure to get a numeric and not text.

[vivientexier]

=Interval(Now() - Addmonths(Today(), -2), 'mm')

Try this, it is working fine. Your date format may be wrong.

[Sokkorn · Accepted solution]

Hi,

You may try this in text object

=Interval(Date#('1/9/2013 29:55','MM/DD/YYYY hh:mm')-Date#('1/8/2013 20:55','MM/DD/YYYY hh:mm'),'mm')

Regards,

Sokkorn

[Anonymous]

Can Also Try

which gives more precise answer

(num((Timestamp(Timestamp#('2013-1-9 19:55','YYYY-MM-DD hh:mm'))-

Timestamp(Timestamp#('2013-1-8 20:55','YYYY-MM-DD hh:mm')))))*24*60