topic Re: Timeformat in QlikView

Timeformat

n1ef5ng1 — Wed, 08 May 2013 04:32:15 GMT

Hi Guys,

I have two field call Arrival_Time and Departure_Time

The format for this two time is

10/01/2012 16:48:00

and

01/02/2012 20:00:00

I need to find the difference of this two time(Arrival and Departure) via Days

Any ideas on how I can do it, thank you

sushil353 — Wed, 08 May 2013 04:59:43 GMT

Hi,

Check out interval function:

interval( A-B, 'D hh:mm' ) where A=97-08-06 09:00:00 and B=96-08-06 00:00:00 returns:

HTH

Sushil

kumarnatarajan — Wed, 08 May 2013 05:02:36 GMT

Hi,

Try the below syntex.

EX : =Interval(Arrival_Time-Departure_Time,'DD')

Wed, 08 May 2013 05:22:32 GMT

Extract date from both the dates using Function DATE and then convert it into number format and then operate the subtraction

Num(Date (Arrival_Time,'DD/MM/YYYY')) - Num(Date (Departure_Time,'DD/MM/YYYY'))

another way is

using the same technique, convert into date and then use DATEDIFF function.