Age

[Klam]

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

 

[Jeanette Cunningham]

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

 

[Douglas J. Steele]

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.

 

[John W. Vinson]

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]

 

[Klam]

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