If you want to delete records between two dates, you would just put that information in the
WHERE
clause like so:
DELETE
FROM myTable
WHERE myDate >= '12/9/2012' AND myDate <= '20/9/2012'
I would run that as a
SELECT
statement first to make sure you are getting the right records before actually running the delete. Basically, just replace the
DELETE
with
SELECT *
like so:
SELECT *
FROM myTable
WHERE myDate >= '12/9/2012' AND myDate <= '20/9/2012'