Change in February Dates

  • Thread starter Thread starter Phillip Armitage
  • Start date Start date
P

Phillip Armitage

I have a comma separated text file that contains log entries for printing.
Each line in the log contains an entry for a date in the form "mm/dd/yyyy".
For some reason, when I import this data into an Access 2003 database (one
I've been using successfully for two years) it records the dates for the
first half of the month in "mm/dd/yyyy" format, but the latter half as
"dd/mm/yyyy". That is, Feb 12, 2008 (and earlier dates in the month) is
recorded in the database as 02/12/2008, but Feb 13, 2008 (and later dates in
the month) is recorded as 13/02/2008.

The data element is a Date/Time one.

Any idea as to why Access 2003 would be having this problem?
 
Found the "problem". Sometime over the past month the regional settings on
the computer running the database program were switched from English (US) to
English (Canadian). This caused problems with the import routine. I've now
added code to read the date value in the log file as mm/dd/yy format and
write it to the database in the format specified by the current regional
settings.

All is now working.

TTFN
 
Back
Top