I see many example of age from date of birth
Howevere when the year of the date of birth is over 1929 ie age 88 the age
turn out to be negative say dob is 01 jan 1928 or less
Can any ne help?

klam

Klam,
have a look at this about age functions and why some work and others do not.
http://www.allenbrowne.com/func-08.html

Jeanette Cunningham

"Klam" <(E-Mail Removed)> wrote in message
news:3902CAC7-F84A-417C-9AFA-(E-Mail Removed)...
>I see many example of age from date of birth
> Howevere when the year of the date of birth is over 1929 ie age 88 the age
> turn out to be negative say dob is 01 jan 1928 or less
> Can any ne help?
>
> klam

Sounds as though you're using 2 digit years, rather than 4 digit years.

By default, Windows will treat years 00 to 29 as 2000 to 2029, and years 30
to 99 as 1930 to 1999. (The cut-off date can be changed in Regional and
Language Options in the Control Panel)

The solution is to use 4 digit years.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Klam" <(E-Mail Removed)> wrote in message
news:3902CAC7-F84A-417C-9AFA-(E-Mail Removed)...
>I see many example of age from date of birth
> Howevere when the year of the date of birth is over 1929 ie age 88 the age
> turn out to be negative say dob is 01 jan 1928 or less
> Can any ne help?
>
> klam

On Tue, 15 Jan 2008 22:41:00 -0800, Klam <(E-Mail Removed)>
wrote:

>I see many example of age from date of birth
>Howevere when the year of the date of birth is over 1929 ie age 88 the age
>turn out to be negative say dob is 01 jan 1928 or less
>Can any ne help?
>
>klam

If you enter the date of birth as (say) 2/14/29 it will assume you mean 2029.
If you enter 2/14/08 it will assume 2008. Would you want 2/14/08 to mean 1908
routinely??

For birthdates you must use four digit years. Access must make some assumption
to determine the century of two digit years; by convention, 00 through 29 are
assumed to be in the 21st centruy, 30 through 99 in the 20th.

John W. Vinson [MVP]

I do not know why I could not log in but now I can
Thank you
--
klam


"John W. Vinson" wrote:

> On Tue, 15 Jan 2008 22:41:00 -0800, Klam <(E-Mail Removed)>
> wrote:
>
> >I see many example of age from date of birth
> >Howevere when the year of the date of birth is over 1929 ie age 88 the age
> >turn out to be negative say dob is 01 jan 1928 or less
> >Can any ne help?
> >
> >klam
>
> If you enter the date of birth as (say) 2/14/29 it will assume you mean 2029.
> If you enter 2/14/08 it will assume 2008. Would you want 2/14/08 to mean 1908
> routinely??
>
> For birthdates you must use four digit years. Access must make some assumption
> to determine the century of two digit years; by convention, 00 through 29 are
> assumed to be in the 21st centruy, 30 through 99 in the 20th.
>
> John W. Vinson [MVP]
>