Capture Birth YEAR only

M

Meryl

I want to capture a person's birth year (not full date, since it may not
always be known). How do I set that up?

Thank you.
Meryl
 
M

Mike Painter

Meryl said:
I want to capture a person's birth year (not full date, since it may
not always be known). How do I set that up?

Thank you.
Meryl
Click to expand...

Format the output for just the year or use a non date field.
 
D

Douglas J. Steele

Mike Painter said:
Format the output for just the year or use a non date field.
Click to expand...

Using a non-date field is really the only option, Mike. Date fields can only
store complete dates.
 
D

Douglas J. Steele

Meryl said:
If I use a non-date field then how do I calculate age?

Meryl
Click to expand...

You can't, at least not accurately.

You can subtract the year from the current year, but if someone is born in
1995, you can't be sure if they're 9 or 10 if you don't know when their
birthday is.
 
M

Mike Painter

Meryl said:
If I use a non-date field then how do I calculate age?
Meryl
Click to expand...

You can't do it correctly if you only have the year.
You will be one year off on average about half the time.

If you do have a full or partial date then a date field is the best choice
but you will have to add some rules.
If the full date is known enter it.
if the month and year is known enter 15/month/year.
If only the year then use 15/6/year.
You could do this in three fields and convert to a date.

What is this being used for?
 
A

adsl

Douglas J. Steele said:
You can't, at least not accurately.

You can subtract the year from the current year, but if someone is born in
1995, you can't be sure if they're 9 or 10 if you don't know when their
birthday is.
Click to expand...
 
A

adsl

Mike Painter said:
You can't do it correctly if you only have the year.
You will be one year off on average about half the time.

If you do have a full or partial date then a date field is the best choice
but you will have to add some rules.
If the full date is known enter it.
if the month and year is known enter 15/month/year.
If only the year then use 15/6/year.
You could do this in three fields and convert to a date.

What is this being used for?
Click to expand...
 
A

Adam

Working in a queary:

Try This...

DOBYr:
DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd"))

Adam.......
 
Top