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]

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

[marco_puccetti]

Does the interval work with years?

Interval(Date1-Date2,'YYYY')

Marco

[buzzy996]

tht will give results some thing like this,

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

[marco_puccetti]

With Age function it works.

Thanks

[#6]

so cool, never heard about it