Filtering dates

[Tonatiuh]

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?

[Clunietp]

Maybe this way:

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


Are you using ADO or DAO? Or is this just in Access?

[Tonatiuh]

Didn't function that way cluniet. I'm using ADO 2.1, VB6 and FoxPro as database.