topic Re: Date in QlikView

Date

Fri, 24 Apr 2015 21:37:13 GMT

Good afternoon!

I need your help, I have to perform a subtraction of hours of two fields that are start_date and end_date , the dates are in the format DD / MM / YYYY HH : MM , subtraction of those fields that I do is just a work period 8 am to 5 pm ... How I can do to make this subtraction and take only that range of time?

Re: Date

MK_QSL — Fri, 24 Apr 2015 21:55:52 GMT

=Interval(Timestamp#(End_Date,'DD/MM/YYYY hh:mm')-Timestamp#(Start_Date,'DD/MM/YYYY hh:mm'),'hh:mm')

Re: Date

Anonymous — Sat, 25 Apr 2015 15:01:40 GMT

I've answered a similar question recently. See attached file.

(The work hours there from 8 am to 6 pm, it is defined in script lines 12 and 13, you can change as needed).

Re: Date

Tue, 28 Apr 2015 16:46:14 GMT

Hi Manish Kathia, thank you very much for the help, but the ranges shown me comes out even 24 hours, the range I need is only 8 am to 5 pm.

Re: Date

Tue, 28 Apr 2015 16:48:58 GMT

Hi Michael Solomovich I would greatly aid your contribution, which could review the attachment?

Re: Date

Anonymous — Tue, 28 Apr 2015 16:52:52 GMT

Not sure I understand the question...

The attachment has been waiting for your review for a few days already

Re: Date

Tue, 28 Apr 2015 17:32:29 GMT

Sorry I was not clear, what I am saying is that there is an attachment, or where I can check that file?

Re: Date

ankitaag — Tue, 28 Apr 2015 20:10:48 GMT

He has already attached an application for you

Re: Date

vishalarote — Wed, 09 May 2018 11:13:06 GMT

=Timestamp(timestamp(Timestamp#(startdate,'DD/MM/YYYY hh:mm:ss TT'),'hh:mm TT')-timestamp(Timestamp#(enddate,'DD/MM/YYYY hh:mm:ss TT'),'hh:mm TT'),'hh:mm TT')

Re: Date

vishalarote — Wed, 09 May 2018 12:13:10 GMT

sorry replace startdate to enddate

=Timestamp(timestamp(Timestamp#(enddate,'DD/MM/YYYY hh:mm:ss TT'),'hh:mm TT')-timestamp(Timestamp#(startdate,'DD/MM/YYYY hh:mm:ss TT'),'hh:mm TT'),'hh')&' Hr'

it will show 09 Hr