topic Re: Timestamp Subtract in QlikView

Timestamp Subtract

Thu, 04 Jun 2015 09:49:03 GMT

Below is the requirement

MAR ALT_TIME ACT_TIME

XXXXXXXXXXXXXX 2015-01-27T04:54:54.62Z 2015-01-27T07:43:10.49Z

How to find the difference in the Timestamp

Regards,

Senthil

PrashantSangle — Thu, 04 Jun 2015 09:57:27 GMT

Hi,

Use Interval()

like Interval( ACT_TIME- ALT_TIME,'hh:mm')

Regards

swuehl — Thu, 04 Jun 2015 10:01:45 GMT

If you need to interprete the timestamps:

=interval(

(date#(subfield('2015-01-27T07:43:10.49Z','T',1),'YYYY-MM-DD')+time#(TextBetween('2015-01-27T07:43:10.49Z','T','Z'),'hh:mm:ss.ff'))

(date#(subfield('2015-01-27T04:54:54.62Z','T',1),'YYYY-MM-DD')+time#(TextBetween('2015-01-27T04:54:54.62Z','T','Z'),'hh:mm:ss.ff'))

,'hh:mm:ss.ff')

PrashantSangle — Thu, 04 Jun 2015 10:05:15 GMT

Hi,

You can also try

Time(num(ACT_TIME - ALT_TIME),'hh:mm')

Regards

Thu, 04 Jun 2015 10:18:13 GMT

Thanks Mate