 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / December 2004can't enter early 1900's date
whenever i put in someones b-day, say from 1900-1930, (ex. 01/20/24) it always comes up 2000-2030. I try to delete it and manually put it in however it won't take. Help! I Either use 4 digit years, or go to the Control Panel and open up the Regional Settings applet. You should find an option there on the Date tab (available when you click the Customize button if you're using XP) that lets you control how Windows interprets 2 digit years.  SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > whenever i put in someones b-day, say from 1900-1930, (ex. 01/20/24) it > always comes up 2000-2030. I try to delete it and manually put it in however > it won't take. Help! I >whenever i put in someones b-day, say from 1900-1930, (ex. 01/20/24) it >always comes up 2000-2030. I try to delete it and manually put it in however >it won't take. Help! I Birthdates must ALWAYS use four digit years. My friend Lida was born in '97; I believe one of her great-great-granddaughters was born in '97. Change the Format property of the birthdate field from Short Date to mm/dd/yyyy (and remove any input mask that you may have on the field). Access must make some arbitrary decision about how to handle two digit years; you've correctly analyzed its choice! You can update existing records without retyping them using an Update query; if you're sure that there aren't any kids under four in the database (i.e. all 00 - 29 dates should be in the 1900's) you can run an Update query updating DateOfBirth to DateAdd("yyyy", -100, [DateOfBirth]) using a criterion of >= #1/1/2000# John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps I can't seem to discover how you change the properties of the birthdate field, I tried right clicking and highlighting it and going to format at the top, but no help, can you further elaborate on this issue? > >whenever i put in someones b-day, say from 1900-1930, (ex. 01/20/24) it > >always comes up 2000-2030. I try to delete it and manually put it in however [quoted text clipped - 24 lines] > Tuesday 11am EDT - Thursday 3:30pm EDT > http://community.compuserve.com/msdevapps What property are you hoping to change? SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > I can't seem to discover how you change the properties of the birthdate > field, I tried right clicking and highlighting it and going to format at the [quoted text clipped - 28 lines] > > Tuesday 11am EDT - Thursday 3:30pm EDT > > http://community.compuserve.com/msdevapps >I can't seem to discover how you change the properties of the birthdate > field, I tried right clicking and highlighting it and going to format at the > top, but no help, can you further elaborate on this issue? Single click it and then display the property sheet. You will find what you want on the Format tab of the property sheet. SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com >I can't seem to discover how you change the properties of the birthdate >field, I tried right clicking and highlighting it and going to format at the >top, but no help, can you further elaborate on this issue? Open the Table in design view. Select the birthdate field (just mouseclick it, don't right click or do anything else fancy). Look on the lower left corner of the screen - depending on how the screen size has been changed you might need to scroll down. You should see a box with all of the properties of the selected field; the Format property is second from the top. 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
|
©2008 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.