Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Maybe you can try Interval(Date2-Date1,'mm')
Regards,
Sokkorn
=Interval(Date1 - Date2, 'mm')
Of course, you can use another format (example : 'D hh:mm')
it's not working.
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.
=Interval(Now() - Addmonths(Today(), -2), 'mm')
Try this, it is working fine. Your date format may be wrong.
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
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