I have used this two ways to tray to filter by som date filed and I got an error.

SELECT *
FROM Orders
WHERE ShippedDate = #5/10/96#

SELECT *
FROM Orders
WHERE ShippedDate = DateValue('5/10/96')

Any odea about any other way to do it?