In Access the Date Updated entry 14/04/05 returns as 05/04/2014.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shelley - 14 Apr 2005 06:45 GMT

While creating a new database in Access 2003 and in the coloumn "Date
Updated" of the new record when I type the date 14th April 2005 the date
returns as 5th April 2014. The format is dd/mm/yy
This does not happen to for eg. 12th April 2005 entry however.

Reply to this Message

m l - 14 Apr 2005 22:02 GMT

It looks to me like you've got the wrong format in the Control Panel.
Don't forget that Access takes its formatting from the Windows Control
Panel - date, time, numbers, currency, etc.
Go to the Control Panel -> Regional and Language Options and Customize your
short date format to dd/mm/yy
The fact that it works with some dates is probably because you're entering a
2-digit year.
My recommendation is to always go with the ANSI format: yyyy-mm-dd

Mike L
I have a free tutorial on Access that you might want to check out.
It's at www.profsr.com Profsr.com Tutorials

> While creating a new database in Access 2003 and in the coloumn "Date
> Updated" of the new record when I type the date 14th April 2005 the date
> returns as 5th April 2014. The format is dd/mm/yy
> This does not happen to for eg. 12th April 2005 entry however.

Reply to this Message