greater than date 1

[brendanDATA]

I am trying to insert records where a field has a certain value AND the date is after 11/13/2004. When I run the query, it seems to ignore the DATE and just inserts all of the records where the other field has the certain value. The query currently looks like this:

INSERT INTO New_table
SELECT [01_10_05complete].*
FROM 01_10_05complete
WHERE (((([01_10_05complete].Date_Added) > 11/13/2004)) and (([01_10_05complete].Venue_Type)="value"));

Can someone help with the date syntax? The column is formatted in MM/DD/YYYY right now.

 

[r937]

... WHERE Date_Added > #11/13/2004#

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[infomania]

Brendan

You might try putting # literals around the date
INSERT INTO New_table
SELECT [01_10_05complete].*
FROM 01_10_05complete
WHERE (((([01_10_05complete].Date_Added) > #11/13/2004#)) and (([01_10_05complete].Venue_Type)="value"));

infomania