 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / February 2008Age
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 >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.  SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) >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 >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 Signatureklam > >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 [quoted text clipped - 12 lines] > > John W. Vinson [MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.