how to calculate the age according to the selected date?

[carlos13]

1. I have a table from 2002 to 2013 movements..

2 calculate the current age: age (today (), FEC_NACIMIENTO) as AGE.

3. I have the field: FEC_MOVIMENTO, which is the date of entry to the client system.

I have the date of birth and date of movements of a client, need know the age  that  had in each Movements  year , and I show it in a table, which occupied a formula for calculations. So i need a little help with this.

I will be very grateful with any response and for your time. And excuse my english, is not very good.

Regards.

Carlos

[carlos13]

any ideas please

[#3]

For calculating the age at the movement date , Date of movement - DOB of the client will do.Could you post a sample qvw?

[#4 · Accepted solution]

Hi Carlos,

The funtion age is helpful for your requirement.

Age(FEC_MOVIMENTO, FEC_NACIMIENTO) as Age

Regards,

Ricardo

P.D: ¿Hablas español? Si gustas me explicas en ese idioma y te ayudo.

[carlos13]

Gracias Ricardo eso es lo que ocupaba, es que no sabia trabajar bien la función age.

Saludos, Carlos