Date in Access 2000

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Date in Access 2000

Logged in as: Guest

arrSession:exec spGetSession 2,3,1457

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> Date in Access 2000
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Date in Access 2000 - 10/12/2004 7:04:19 PM

abhujan

Posts: 1
Score: 0
Joined: 10/12/2004
From: Mauritius
Status: offline

Hi every1

am having a big headache with short date format in Access 2000
i want the date to be stored as dd/mm/yyyy but its always in US format mm/dd/yyyy.

i hav changed my regional settings to English UK and even put the Format properties of Date/Time in access 2000 database to dd/mm/yyyy but its not working yet.

can any1 plz help

_____________________________

Arvind_leo

Post #: 1

Re: Date in Access 2000 - 10/21/2004 2:57:14 AM

Scotty Mo

Posts: 8
Score: 0
Joined: 10/16/2004
From:
Status: offline

In Access, as in all of the Microsoft Office suite, dates are stored in the same way. While they can be represented in the way of mm/dd/yyyy or dd/mm/yyyy, it's stored as an 8-byte floating-point number. The number before the decimal point stores the date, the number after the decimal point stores the time. If you convert the number 2 into a date, it will give you 01/01/1900 at 12:00:00AM. The number 3 will give you 01/02/1900 and so on.

What you want to do is set the format on your date fields to "dd/mm/yyyy" in the design view of your table. This will cause your data to show in this way. If you've already made forms or reports with these fields, you may need to manually update their formats as well.

Good luck
Scotty Mo

(in reply to abhujan)