Dates and Greater Than / Less Than

[chris5g]

I'm using a Access to store the dates I need to compare and I want to delete a record that has a creation date prior to the current date.

What is the SQL statement that will do this? I tried to use a string like the one below but it didn't work. If I use > it works but deletes everything.

&quot;DELETE FROM tablename WHERE mydate < &quot; & Date

 

[swampBoogie]

DELETE FROM tablename WHERE mydate < Date()

 

[mwolf00]

&quot;DELETE FROM tablename WHERE mydate < #&quot; & formatDate(Date()) & &quot;#&quot; Get the Best Answers! faq333-2924
Is this an asp FAQ? faq333-3048

mikewolf@tst-us.com

 

[chris5g]

The #date# did the trick,thanks a whole bunch!