In Access table how do you enter date as 29-Apr-2005

[Guest]

I can enter date in dd-mmmm-yy format using medium date. How can I add full
year such as 2005 ?

 

[John Vinson]

I can enter date in dd-mmmm-yy format using medium date. How can I add full
year such as 2005 ?

You can set the Format to dd-mmmm-yyyy (either in Access, or in your
Regional settings).

Note that a Date is stored as a double float number - the format is
NOT stored, it only controls how the data is displayed. If you have
the Format set as above, you can type 4/26 into the textbox and *see*
29-April-2005 since it will automatically add the current year and
reexpress the value using your selected format.

John W. Vinson[MVP]