Access 2000 date format inverted

  • Thread starter Thread starter Dev PREF84
  • Start date Start date
D

Dev PREF84

I am trying to save a date field (dd/mm/yyyy) into Access 2000 on the exact
format.
Access only can save only with the format mm/dd/yyyy. All parameters and
mask are correct for dd/mm/yyyy.
Is somebody yet found this problem ?
Is a correction existe ?
Thanks for help
BV
 
-----Original Message-----
I am trying to save a date field (dd/mm/yyyy) into Access 2000 on the exact
format.
Access only can save only with the format mm/dd/yyyy. All parameters and
mask are correct for dd/mm/yyyy.
Is somebody yet found this problem ?
Is a correction existe ?
Thanks for help
BV


.
Click to expand...

BV,

If you change your regional settings in the control
panel you can achieve this. However, that works for
everything in your PC.

If you want it to change on a form (or on the table
but for upsizing I don't recommend doing it on the table)
then you can put in dd/mm/yyyy for the format of your date
text box.

hth

Ivan
 
Access does not save a datetime field in any format. It always stores a
date as a number. The integer portion is the number of days since Dec 30,
1899; the decimal portion is the fraction of a day. For example right now
if I entered a date into Access, it would store
37945.5381712963

How it is displayed to you is dictated by the format settings.

Dates can be entered as dd/mm or mm/dd. I'm not sure if 01/08/03 is August 1
or Jan 8, or what? Access does not make random decisions about this, it
uses the short date settings on your computer to assume what you mean by
your entry.

So on one computer it could be interpreted one way, and on another computer,
a different way.

Go into Control Panel, Regional Settings, Date tab, and see what your
computer is set to. If it is
m/d/y and you enter 08/05/03, it will assume you mean Aug 5. However if you
enter 13/05/03, that
doesn't conform to your Regional Settings (there is no 13th month). Access
will still enter a date
for you though - it 'helpfully' spins your entry around until it can make
sense of it - May 13,2003.
This is why it can be very confusing to users, as it would appear that
Access arbitrarily changes
your date entries. It's really only doing this after the 12th of the month.

Change your Regional Settings to suit how you like to enter dates. I would
also suggest you choose
a format for your field/control that is unambiguous such as dd/mmm/yyyy.
This way you will see
immediately whether Access interpreted your entry as you meant.

For more information on dates see
http://users.bigpond.net.au/abrowne1/ser-36.html
 
Back
Top