Get age from 198004

[#1]

Hi

How can I get the age in year when I have a field "born" which are as 198004 or 200512?

/thanks!

[CELAMBARASAN]

Hi,

Format this date using Date# like

     age(Date(Date#(Field,'YYYYMM')),Today())

Celambarasan

[#3]

Hi. I´d got a negativ value from that, correct age but a - (minus) before.

Tried to used this, seems to work. 

Year(today()) - left(Field, 4) AS Age

[CELAMBARASAN · Accepted solution]

Hi,

     Sorry you have to use like this

     age(Today(),Date(Date#(Field,'YYYYMM')))

     in your expression if the date is 201112 then it gives the age as 1.is it right?

Celambarasan

[#5]

Hi,

create a new field in the name of age in the backend with following expression

AGE(Today(),date(date#([Date Of Birth]),'DD-MM-YYYY')) AS AGE

hope it helps.