Issue with dates!!! access inverts dyas with months

[Jorge Novoa]

Hello everyone!

I got an issue with dates in access, and I Hill apréciate your help.

How can I set my computer or access to NOT invert days with months in date
fields of a table.????

I need the date format "dd/mm/yyyy"

My PC is already configured to that in the regional settings (Windows
professional xp sp2 spanish, office 2003 pro. Spanish), short date format:
"dd/MM/yyy"

My date fields already have the short date format.

It happens that dates like June, 25 (25/06/2007 for me) were stored just
fine, but dates like July 2 (01/07/2007 for me), they are stored as Feb, 7th
(02/07/2007)

How can I push access not to do what it wants, but respect the date format I
manage in my computer.

Actually the values are stored like I say, I mean this is not a display
matter, 'cause when I Query something with a parameter like july 2nd
(02/07/2007) it returns nothing, of course access sored it like Feb 7th ...
07/02/2007!!!!

I know this issue is nothing strange, can anyone help me, please?

Thank you very much,

Regards,

Jorge Novoa.

 

[Allen Browne]

Internally, Access stores the dates as numbers, where the integer part
presents the date (number of days since 30 Dec 1899), and the fraction part
is the time (as a fraction of a day.)

Consequently, if the wrong date value is already stored in your table, there
is no way to fix it by adjusting the display format. You will need to
identify and correct each one that has the wrong date stored.

You sound like you understand the idea of how to adjust the display.

This article explains the principles:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

 

[DAVID]

How were the dates entered into the database?

If you typed "02/07/2007" into a datasheet, or
into a form bound to a table, that should have
worked. It works for me.

If you used an append or update query to append
or update a date field using a text value, you
should fixup the text value before running the
query. I suggest that you use yyyy/mm/dd or
yyyy.mm.dd format. This is the cannonical SQL
format, and less confusing for me than the
original SQL format mm/dd/yyyy which is your
other option.

If you are just using mdb files, you can also
use the jet serial date number, but that causes
problems if you move to SQL Server (because of
the Lotus 123 compatibility issue).

If you only use english, you can also use
mmm or mmmm formats.


(david)