topic Re: Difference between two dates in QlikView

Difference between two dates

Tue, 12 Aug 2014 08:41:24 GMT

Hi,

I need to calculate the difference between two date for which I have been using the below expression

=round(date(End,'DD/MM/YYYY')-date(Start,'DD/MM/YYYY'))

where start is 21/07/2014 and end is 22/07/2014 and the expected result is 1

But, the value obtained is 0

So can anyone please let me know how this could be acheived.

ashfaq_haseeb — Tue, 12 Aug 2014 08:45:17 GMT

Try below

=Interval(date(End,'DD/MM/YYYY')-date(Start,'DD/MM/YYYY'))

Regards

ASHFAQ

syukyo_zhu — Tue, 12 Aug 2014 08:48:36 GMT

try left(date(End,'DD/MM/YYYY'),10)-left(date(Start,'DD/MM/YYYY'),10)

sibideepak — Tue, 12 Aug 2014 08:50:26 GMT

Store both dates as variable .

And then make subtract ..You must get it

Thanks

Deepak

Tue, 12 Aug 2014 09:33:04 GMT

Hi,

You can use following, get year, month, date from both the dates, then use num on them and get a difference.

for example, difference between 12/08/2014 and 01/01/2014 should be 223. Following code gives this result.

= num(makedate(2014, 08, 12)) - num(makedate(2014, 01, 01))

Thanks,

Arun

SunilChauhan — Tue, 12 Aug 2014 11:01:15 GMT

age(timestamp, date_of_birth)

Returns the age at the time of timestamp (in completed years) of somebody born on date_of_birth.

Examples:

age('2007-01-25', '2005-10-29') returns 1

age('2007-10-29', '2005-10-29') returns 2

age(end,start)

Wed, 13 Aug 2014 12:48:04 GMT

Hi Anushree,

Did you check my answer? Can you confirm if it's correct please.

Thanks,

Arun