FN-FORUM: Weird Access date import/query problem

date posted 16th May 2006 16:46

While transferring data from one Access database to another via VB (It
doesn't seem to matter if it is 2000 or 2002-2003) Short dates in UK format
get converted to US format but only for 1st of each month to the 12th
inclusive.

This is incredibly annoying. Does anyone know of a fix for this issue or do
I have parse each date and reverse the problem ones to resolve it?

I have also noticed that SQL queries will not find the correct dates when
passed the UK format even though the data is stored in UK form. All settings
on the system are set to UK.

Cheers

Ali