[Resolved] Whats with this? Date & ADO

[ChaosT]

Well i'm stumped. This is wierd.

I am using ADO to connect to an Access database. No problems at all.

The database is reasonable size - 60,000 records. each record has a date formatted like this: dd/mm/yyyy.

Here is the query:

$rs = $conn->Execute("SELECT Data, Net FROM Invoice WHERE Job_Date=#$qdate# ");

Now, for every day in the year there are at least 80 records.

Here is the problem:
For any query run for dates in 2005, the days 06 to 12 in ANY month return no results (e.g. 06/05/2005 or 08/03/2005).
For any query run for dates in 2004, the days 01 to 05 in ANY month rerurn no results.

All other dates used return results correctly. Can anyone shed any light on this?

[ChaosT]

Ok - sussed it. Typical.

even though the access database has the dates formatted as dd/mm/yyyy, the query needs to be formatted as mm/dd/yyyy.

jeeeeeeeeeeeeeeeeeeeze.