seconds between two time stamps

[NickHoff]

I have two time stamps start and end in the format 1/1/2015 7:30:00 AM.  How do I go about getting the seconds between the two time stamps?

[sunny_talwar]

Maybe like this:

Interval(StartStamp - EndStamp, 'ss')

Interval(EndStamp - StartStamp, 'ss')

[petter · Accepted solution]

You have an internal representation of timestamps that makes it possible to just subtract one from the other.

It will still be in days so you could multiply them up to seconds: 24 hours * 60 minutes * 60 seconds = 86400

SecondsDiff = ( Timestamp1 - Timestamp2 ) * 86400

This will however make the result into a regular number - and you will not have a timestamp anymore. Using Interval() would solve that.

[MarcoWedel]

(TimestampEnd-TimestampStart)*86400

[MarcoWedel]

wow.

3 answers in the same minute ...

[petter]

It's perfect I love that - Qlik products deserve to have a highly responsive community