Date diff compute year

[marco_puccetti]

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

Marco

[#2]

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.

[Anonymous]

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

[sujeetsingh]

Interval function will help you out

Interval(Date1-Date2,'DD')

[fvelascog72]

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

];

[hic · Accepted solution]

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

     Age(timestamp, date_of_birth)

HIC

[marco_puccetti]

Ok with year we can approximate the age from now.

Thanks

Marco

[jonathandienst]

If you need a more accurate age:

    Floor((Date1 - Date2) / 365.25)

     or

    Ceil((Date1 - Date2) / 365.25)

     or

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

[MK_QSL]

Use this...

Reference

swuehl

[buzzy996]

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