Date Format

H

HRMan

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

Rick B

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
Excell Otpions in office environment 0
Short Date Entries 2
Changing years 2
Convert Text to Date Error 2
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
Countdown macro - display settings 2
Imput mask not working correctly for certain values 2

Top