topic Calculation 2 datetime in hours in QlikView

Calculation 2 datetime in hours

suzel404 — Wed, 17 Oct 2018 22:06:44 GMT

Hi,

ID, STARTDATE, ENDDATE

1	30/10/17 18:59:00	31/10/2017 10:30:00
2	30/10/17 19:16:00	31/10/2017 12:00:00

I want to calculate the delay in hours from startdate and enddate.

INTERVAL(DATE(DATE#(ENDDATE, 'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss') - DATE(DATE#(STARTDATE, 'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss'), 'H') does not work.

Regards,

Re: Calculation 2 datetime in hours

swuehl — Wed, 17 Oct 2018 22:26:09 GMT

Your start dates show only two year digits, hence your format code should show only two 'YY'.

Also check that there are no additional spaces etc. in your field values that are not part of your format code.

Besides that, you don't need to format the dates using Date() function, when you want to format the result of the subtraction using Interval().

Re: Calculation 2 datetime in hours

suzel404 — Thu, 18 Oct 2018 07:43:39 GMT

Thanks,

I'll check !