can't enter early 1900's date

[Guest]

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

 

[Douglas J. Steele]

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.

 

[John Vinson]

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

 

[Guest]

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
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

 

[Douglas J. Steele]

What property are you hoping to change?

--
Doug Steele, Microsoft Access MVP

(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
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
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

 

[Rick Brandt]

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.

 

[John Vinson]

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]