topic Re: Difference between two datetimes in QlikView

Difference between two datetimes

Anonymous — Tue, 10 Feb 2015 07:09:39 GMT

Hi ,

I used the following formula for getting difference between two datetimes

interval(fabs(interval(date(date#(ENDDATETIME,'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss')-

date(date#(STARTDATETIME,'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss'),'ss')),'ss') as Duration.

its working fine

it gives out put like

Duration

But i want to get the out put like

Duration

Please help me.

Thanks,

alexandros17 — Tue, 10 Feb 2015 07:21:04 GMT

Try with

interval(fabs(interval(date(date#(ENDDATETIME,'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss')-

date(date#(STARTDATETIME,'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss'),'s')),'s') as Duration

let me know

Anonymous — Tue, 10 Feb 2015 08:18:58 GMT

Hi saccone,

Its working fine thanks for your help.

Thanks,