Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How can I get the age in year when I have a field "born" which are as 198004 or 200512?
/thanks!
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
Hi,
Format this date using Date# like
age(Date(Date#(Field,'YYYYMM')),Today())
Celambarasan
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
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
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.