delete lines that are from a certain date

[neveu]

hello,

i have a database containing several columns and a date column,

i would like to delete all records for which the date column equals a certain date: for example 12/21/2007.

the format of the date column is date/time

i have written the SQL code like this but it doesn't work [it says it will append 0 zeroes when it should delete 3] ; if i add the apostrophes to the data in the criteria it gives the error 'data type mismatch'

delete from tbl_up where PmntDate=12/21/2007

any ideas what is the problem?

 

[Joe4]

If your date is actally in date format, try this:

DELETE FROM tbl_up WHERE PmntDate=#12/21/2007#

 

[neveu]

thank you very much