Date Format

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

Guest

Hello,
I am new to acces and I am trying to format the date in access so that 1929
reads 1929 and not 2029. How can I do that?

Thank you.
 
HRMan said:
Hello,
I am new to acces and I am trying to format the date in access so
that 1929 reads 1929 and not 2029. How can I do that?

Thank you.
Click to expand...

Type 1929 and that should do it. Most modern databases will default to
2029 if you only type the 29.
 
If you enter 1929, it will display that. If you enter "29" it will assume
2029. If a date is stored as 2029, then you can;t display it as 1929. It
will display what is stored, you just need to make sure to store the correct
information.

Rick b
 

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

Similar Threads

DATE IN ACCESS TABLE 4
Changing years 2
Short Date Entries 2
Convert Text to Date Error 2
Moving Birthdays 5
Imput mask not working correctly for certain values 2
Grouping on certain years - help needed please 9
index/match or vlookup or similar 1

Back
Top