topic Date diff compute year in QlikView

Date diff compute year

marco_puccetti — Wed, 24 Jun 2015 07:56:34 GMT

How can i do to make the year difference from 2 dates? I need it to compute the age.

Marco

Re: Date diff compute year

Wed, 24 Jun 2015 08:05:24 GMT

You should be able to use FABS(Year(Date1)-Year(Date2))

FABS will give you the absolute value so it doesn't matter which way around the dates are.

Re: Date diff compute year

Anonymous — Wed, 24 Jun 2015 08:06:35 GMT

year(date1)-year(date2)+1 (( +1 depending what result you expect for same year (0 or 1)

or not that what you want? then specify more your requirements

Re: Date diff compute year

sujeetsingh — Wed, 24 Jun 2015 08:09:50 GMT

Interval function will help you out

Interval(Date1-Date2,'DD')

Re: Date diff compute year

fvelascog72 — Wed, 24 Jun 2015 08:09:54 GMT

Hi,

Try this:

DATA:

LOAD

if(month(DeadDate)<month(BornDate),year(DeadDate)-year(BornDate)-1,year(DeadDate)-year(BornDate)) as "Age"

Inline [

BornDate, DeadDate

01/10/1950, 02/05/2015

01/01/1960, 03/08/2015

];

Re: Date diff compute year

hic — Wed, 24 Jun 2015 08:13:25 GMT

There is an "Age" function that does exactly this:

Age(timestamp, date_of_birth)

HIC

Re: Date diff compute year

marco_puccetti — Wed, 24 Jun 2015 08:13:43 GMT

Ok with year we can approximate the age from now.

Thanks

Marco

Re: Date diff compute year

jonathandienst — Wed, 24 Jun 2015 08:14:20 GMT

If you need a more accurate age:

Floor((Date1 - Date2) / 365.25)

Ceil((Date1 - Date2) / 365.25)

Round((Date1 - Date2) / 365.25, 0.1)

Re: Date diff compute year

MK_QSL — Wed, 24 Jun 2015 08:20:34 GMT

Use this...

Reference

swuehl

Re: Date diff compute year

buzzy996 — Wed, 24 Jun 2015 08:28:33 GMT

use Interval() ,if u need u can specify format as well with the function.

Re: Date diff compute year

Wed, 24 Jun 2015 08:35:11 GMT

for example,

year(date) - year(birthdate) - if(date < MakeDate(year(date), month(birthdate), Day(birthdate)), 1, 0)

if checks if persons birthday already was in this year or not

Re: Date diff compute year

marco_puccetti — Wed, 24 Jun 2015 08:39:48 GMT

Does the interval work with years?

Interval(Date1-Date2,'YYYY')

Marco

Re: Date diff compute year

buzzy996 — Wed, 24 Jun 2015 08:54:14 GMT

tht will give results some thing like this,

if tht's ur secnario,why can't use =Num(Year(Variable1)-Year(Variable2))?like this.

Re: Date diff compute year

marco_puccetti — Wed, 24 Jun 2015 09:48:24 GMT

With Age function it works.

Thanks

Re: Date diff compute year

Wed, 24 Jun 2015 15:20:37 GMT

so cool, never heard about it