Date problems in MSAccess

[Connie]

Hi all,

I am in Australia, we have the date format dd/mm/yy.

In two seperate Database applications I am getting issues
with the date reverting to mm/dd/yy format, but only if
the date is before the 12th of the month, after the 12th
it works fine.

This is an extremely frustrating issue and any help would
be appreciated.

Connie

 

[ss01]

It probably to do with your comps having an American date format. Go to your
Setting/Control Panel /Regional Setting and change it to Ozzies date and
time and also look into the daylight hours.

Cheers mate.

silvre

 

[John Vinson]

Hi all,

I am in Australia, we have the date format dd/mm/yy.

In two seperate Database applications I am getting issues
with the date reverting to mm/dd/yy format, but only if
the date is before the 12th of the month, after the 12th
it works fine.

An Access Date/Time field is *stored* internally as a Double Float
count of days and fractions of a day since midnight, December 30,
1899. The format - dd/mm/yyyy, mm/dd/yy, ddd-yyyy or whatever - is
applied at display time.

Literal Dates in SQL queries MUST be in either mm/dd/yy(yy) format or
an unambiguous format such as dd-mmm-yyyy (17-Sep-2003). However, the
way the Short Date format is interpreted - dd/mm/yy or mm/dd/yy -
depends on the settings in the Control Panel of your computer. This
may be the root of the problem; open Control Panel... Regional and
Language and check the setting there. You can set the Format
explicitly to 'dd/mm/yyyy' or any of a huge variety of formats rather
than relying on the computer setting; if the database is to be
distributed, this might be a good idea!

 

[Van T. Dinh]

I am in Australia but I don't have this problem. The
first thing I would check is the Regional Settings
(including date/time in Regional Settings) of your Win
OS. Unfortunately, lots of PC techs install Win OS
without even bothering to select the correct Regional
Settings for users.

There is also the 4-dit year option in Access Tools /
Options ... / General Tab.

HTH
Van T. Dinh
MVP (Access)