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?
Printable View
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?
Maybe this way:
SELECT *
FROM Orders
WHERE ShippedDate = '5/10/96'
Are you using ADO or DAO? Or is this just in Access?
Didn't function that way cluniet. I'm using ADO 2.1, VB6 and FoxPro as database.