Older than # days SqlCommand1->CommandText = "DELETE FROM tblMyTable WHERE DATEDIFF(day, getdate(), MyColumnName) < -10"; //Delete all records older than # days ago SqlCommand1->ExecuteNonQuery();