Need Help .."Data Type mismatch"

[lena]

strTableName Data :

time (field)
10/29/2014 12:05:52 AM
10/28/2014 12:15:51 AM
10/27/2014 7:52:48 PM
10/26/2014 7:52:48 PM



iwant to delete 27 and 26 data

txtLastDate =10/29/2014 12:05:52 AM

txtDate = Format(txtLastDate - 2, "yyyy-mm-dd hh:mm:ss")
DoCmd.RunSQL "DELETE * FROM " & strTableName & " WHERE time < '" + txtDate + "'"

error : Data Type mismatch in criteria expression.

can anyone Help me .. how is the correct writing .
any suggestions?

Thanks

[amrut]

If the field is of type date/time then the ' ( single quote) should be replaced with #.
DoCmd.RunSQL "DELETE * FROM " & strTableName & " WHERE time < #" + txtDate + "#"

[Missinglinq]

I also believe that you'll find that the + signs you've used for concatenation will bomb out in a SQL Statement! You need to replace the + signs with Ampersands, as you did in the first part of the statement, so that your final statement would be

"DELETE * FROM " & strTableName & " WHERE time < #" & txtDate & "#"

While the use of the + sign for concatenation is sometimes tolerated, in VBA code (for backwards compatibility, presumably) this isn't always true, and thus the practice should really be avoided, and the + sign reserved for doing math, in VBA code and SQL.

Linq ;0)>