I can't get the correct date on access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am entering data, When I put in someones birthday whose was born in the
early 1900's say from 1901 to 1930, the date 2001 to 2030 always pops up. I
try to clear the entry and manual put in the 19 before the last two digits
for the year but it won't take.
 
There should be no problem entering the full 4-digit year, unless you have
specified an Input Mask in the Field in the Table, or an Input Mask in the
Textbox on the Form.
 
shriner said:
I am entering data, When I put in someones birthday whose was born in
the early 1900's say from 1901 to 1930, the date 2001 to 2030 always
pops up. I try to clear the entry and manual put in the 19 before
the last two digits for the year but it won't take.

You are on the right track. You need to enter the long year date.
However somewhere your date format is set for the short year date format.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top