Inconsistant dates in table fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Access 2002 database with a number of tables. Some tables have a
date field which store the data and time a record is change. these tables
(and fields) are update using a form and with SQL in the event procedure.

The problem I am have is this:

Some tables are updated with the correct date format ("dd/mm/yyyy") while
other tables are updated with the incorrect format ("mm/dd/yyy") for my
purposes.

All the SQL statements contain the same "#NOW()#" syntax, and my Locales
setting is set to "UK"

Could someone point me in the right direction.

Many thanks
 
Some tables are updated with the correct date format ("dd/mm/yyyy")
while other tables are updated with the incorrect format ("mm/dd/yyy")
for my purposes.
Click to expand...

If these are genuine DateTime fields, then they are not actually stored in
either format: they are just numbers that code the exact day and second.
You may be either (a) suffering from some overzealous form designer putting
unnecessary formats on his text boxes; (b) sufferinng from some overzealous
query designers hard coding formats into his SQL commands; or (c) suffering
from some undertrained database designer using text fields instead of
datetimes.

Best of luck :-)


Tim F
 
Back
Top