Access/ASP Date Format Problem

Hi,

I have an access database which has a date field. I've entered all of the dates in valid UK format (dd/mm/yyyy). An example of the table looks like this:

Id| SeminarName | SeminarDate
1 | Introduction | 18/02/2006
2 | Other stuff | 19/02/2006



When I do:

SELECT * FROM tblSeminar WHERE SeminarDate=#18/02/2006#;


It doesn't return any records. If I remove the WHERE SeminarDate... it works fine, likewise if I use:

SELECT * FROM tblSeminar WHERE SeminarDate=#02/18/2006#;

So something is causing the date not to match.

I'm using <%Session.lcid = 2057%> at the top of all of my pages, and am hoping to keep all formatting in UK dd/mm/yyyy format.


Can anyone help here?? Thanks very much...