I am producing a sporting website and wish to show all fixtures based on a certain date.
Within my MS Access database I have a table called tblFixtures and a column within the table called FixtureDate.
This FixtureDate column is set as Date/Time with a short date format.

At present I have a page (1.asp) that lists all DISTINCT Fixtures in a drop down list and posts the FixtureDate information (DD/MM/YYYY) to a second page (2.asp).

On this second page a recordset is set to filter the data where the FixtureDate column is equal to the posted form.

The problem is that they both appear to be in the following format DD/MM/YYYY but where data in the formatting matches it is not shown.

I assume that the formatted date I am entering into the SQL on 2.asp is not in the correct format for MS Access and Short Date formatted column.
Can anybody advise?

can you show some code?

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
can you show some code?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>