I need a simple script to delete data older than 6 months.
Posted on 2008-06-10
Hello, I have a simple data table with "Key Sequence, name, devicename, originstation, winlogin_name, date, and messageinfo" columns.
The date column is in DateTime format (MM/DD/YYYY HH:MM:SSAM).
I can remove records older than a specific date range manually but I am trying to write a simple script that when run will "Delete records older than 6 months." Nothing fancy, just simple purge from the table.
I have tried several ideas from the Experts exchange but they all return errors. Is there a simple no frills general command line that would specify "older than 6 months"?