How can I get the age in year when I have a field "born" which are as 198004 or 200512?
Format this date using Date# like
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
Sorry you have to use like this
in your expression if the date is 201112 then it gives the age as 1.is it right?
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.
Retrieving data ...