Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Data Query Help

0 views
Skip to first unread message

Mike

unread,
Aug 12, 2010, 1:57:58 PM8/12/10
to

I have a date column with the date records formatted as: 2006-06-15

Can anyone tell me what correct code is to run a query to retreive
all records before a certain date.

IT will start:

SELECT * FROM database1 WHERE Date =

I am not sure what to put at the end to say date after a certain date.

tia

John Clancy

unread,
Aug 13, 2010, 9:51:12 AM8/13/10
to

Hi tia,

Try:

SELECT * FROM database1 WHERE Date > '2006-06-15'

JC

0 new messages