topic Re: Difference between two time stamp in QlikView

Difference between two time stamp

Wed, 08 Jan 2014 08:59:27 GMT

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 — Wed, 08 Jan 2014 09:04:52 GMT

Hi,

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

Regards,

Sokkorn

vivientexier — Wed, 08 Jan 2014 09:07:25 GMT

=Interval(Date1 - Date2, 'mm')

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

Wed, 08 Jan 2014 09:08:51 GMT

it's not working.

vivientexier — Wed, 08 Jan 2014 09:12:02 GMT

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 — Wed, 08 Jan 2014 09:12:50 GMT

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

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

Sokkorn — Wed, 08 Jan 2014 09:13:43 GMT

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 — Wed, 08 Jan 2014 09:22:53 GMT

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