topic Re: Difference between two dates in days? in QlikView

Difference between two dates in days?

Fri, 24 Oct 2014 15:09:41 GMT

Hi everybody.

I have initial date and final date

i have to make the difference, in expression i put final - initial and its working

but i wanna see this in day and hours, how i make this?

Fri, 24 Oct 2014 15:16:02 GMT

timestamp(InitialDate) - timestamp(FinalDate)

markodonovan — Fri, 24 Oct 2014 15:17:04 GMT

Hi Jeremias,

Here are a few expressions to try out:

SET date1 = "03/04/2014 01:11:12";

SET date2 = "10/04/2014 23:11:12";

//Get the working days

LET testrange = NetWorkDays('$(date1)','$(date2)')-1;

//Calculate the interval with days

LET rangeinterval = Interval('$(date2)'-'$(date1)','D hh:mm');

//Get the time part of the interval

let varTime = Right( '$(rangeinterval)', 5);

//Get the Days part of the interval

let vartempDays = Left( '$(rangeinterval)', Len( '$(rangeinterval)' ) - 6 );

//Create the correct interval - ie: correct days value

let varTimeBetween = '$(testrange) $(varTime)';

All the best .

Mark

www.techstuffy.com

Fri, 24 Oct 2014 15:18:07 GMT

Good! thank you.

I guess it´s timestamp(final) - timestamp(initial) or am i wrong?

MarcoWedel — Fri, 24 Oct 2014 15:18:22 GMT

Interval([final date]-[initial date], 'dd hh:mm:ss')

Fri, 24 Oct 2014 15:20:51 GMT

Thank you! I guess the timestamp function works too. Am i right?

Cheers

Anonymous — Fri, 24 Oct 2014 15:24:00 GMT

Try it!

=interval(final-initial,'D hh:mm')