topic time between 2 dates in second in QlikView

time between 2 dates in second

Thu, 22 Jul 2010 10:17:35 GMT

hi everybody

I search to obtain time difference between 2 dates in second. In my expression i do

Interval(DATE_END-DATE_START,'hhmmss')

for example i have 030200 it means 3 hours 2 min and zero second.

i would like have result in second equals to 10920 seconds

function second on result give me zero

thx for your help

Anonymous — Thu, 22 Jul 2010 10:22:12 GMT

Hi,

You should be able to do this:

Interval(Today()-(Today()-1),'ss');

Thu, 22 Jul 2010 10:28:06 GMT

thx

you are speed;)

it is ok if i make

Interval(DATE_END-DATE_START,'ss')