Query A Short Date Filed

Hi im having issues runing a query on a short date field in my works database calls [Date Logged] I am actually running the query from PHP/ODBC but have tryed running it in acess also..

I am using this query:
SELECT * FROM Maintenance_Dbf
WHERE [Date Logged] = #$date#
ORDER BY Maintenance_ID ASC


Where $date is i have replaced with all of the following date types..

2007-05-21
2007-21-05
21-05-2007
05-21-2007

07-05-21
07-05-21
21-05-07
05-21-07

2007/05/21
2007/21/05
21/05/2007
05/21/2007

07/05/21
07/05/21
21/05/07
05/21/07

yet i cant get any results returned..

Here is an example date from RAW tables 26/04/2007 12:25:33


Any idea's? even the query builder in access doesn't pull up any records :S


Regards
Liam