Hey, I want to delete every record that is in a database that is older than 1 day. The date has been automatically generated and inserted into the table.<BR><BR>How do I go about this?
DateToDelete = Date - 2<BR><BR>Access:<BR>sql = "DELETE columnName FROM tableName WHERE columnNameforDate <= #" & DateToDelete & "#"<BR><BR>SQL Server:<BR>sql = "DELETE columnName FROM tableName WHERE columnNameforDate <= '" & DateToDelete & "'"
If this is something you need to do on a regular basis<BR><BR>you should think of automating it
http://22.214.171.124/forum/asp.asp?M=768789&T=768789&F=20&P=1<BR><BR>Then you need to give the structure of the table as it seems you for some reason split the date up!
No in the end I didnt split it up, the date is all in one field