Remove rows from csv file based on date column
Posted on 2013-11-18
I have a csv file with columns below. The second column is the only field that is an actual date. What we would like to do is remove all rows from the csv file where the date in that column is < 3 days from today whenever run. Don't have any special preference, but figured some type of bat file utilizing DOS commands, or VB script, powershell, etc. We've used things like 'FINDSTR' etc in the past for certain strings, but not a date so not sure where to start. Any help would greatly be appreciated.