How To Get Date Of Birth?

[mohammadagul]

Hi,
Say i have employee's age with me and i want to know his date of birth. i know that this would not give me exact DOB but still how can i calculate DATE Of BIRTH if i have Age of Person?

 

[maxmangion]

his date of birth.

you mean year of birth ?

Create a caluclated field in a query:

Age: Format(Date(),"yyyy")-[YourAgeField])

 

[mohammadagul]

can we get date also like

For age 25 the date should come as 22/12/78 or 1/1/78.

 

[Rich]

Are you asking Access to guess the actual date of birth?

 

[mohammadagul]

lets say an approximate data of birth

 

[ghudson]

+ or - 365 days?

 

[Pat Hartman]

DateAdd("yyyy", Age * -1, Date())

It would be far better to store the DOB rather than Age. How do you know that the stored ages are even close to being accurate?

 

[mohammadagul]

i know that the stored ages are not even close to being accurate but to be honest this is what my employeer is asking. they dont have any records about there employees working with them for the last 10 years. fortunately for them and unfortunately for me they have only age of their employee. God know how they kept that record.... but this is what they are asking. they want date of birth from age.

Thanks again Pat.

 

[maxmangion]

wouldn't be wiser to give a personal details form to the employees and they will fill it in with the correct data rather than using arbitrary date of birth for each employee ? This will also enable you to have your data updated, because there may be several details which may have changed since the last time when your organisation have recorded these details. (eg. addresses, status, position etc.)

In my opinion using arbitrary dates of birth for each employee would limit your database to what it can be used for.