Need a Batch, VB or Powershell script that can parse a file name for a date, and then delete that file older than 90 days.

This is a solution on powershell with the use of a class, there you go:

#requires -version 5
#number of days old
[int]$global:days=90

class file{
    [Datetime]$date
    [string]$QueueType
    [string]$phone1
    [string]$phone2
    [string]$fileName
    
    file(){}
    
    file([string]$split){
        $splited = $split.split('~')
        $this.date = [Datetime]::ParseExact($splited[0],"yyyy-MM-ddTHHmmss",$null)
        $this.QueueType = $splited[1]
        $this.phone1 = $splited[2]
        $this.phone2 = $splited[3]
        $this.fileName = $splited[4]
    }
}

$ClassArray= @()


get-content .\file.txt | %{
    
    $newclass = [file]::new($_)  #New-Object file -ArgumentList $a
    $comparativeDate = (Get-Date).AddDays(-$global:days)

    if($newclass.date -gt $comparativeDate){
        $ClassArray +=$newclass
    }
}

#result
$ClassArray 

Select allOpen in new window

#>
$path = "c:\temp"
$date = get-date
$maxdays = 200
$tokeepdate = $date.AddDays(-1 * $maxdays).ToString("yyyy-MM-dd")
$files = Get-ChildItem -Path $path -Recurse
foreach($file in $files)
    {
    if ($tokeepdate -gt  $file.Name.Substring(0,10) )
        {
        Remove-Item $file.Name -WhatIf   
        }
    }
 

Select allOpen in new window

You've got some Powershell options, so here are some other thoughts.

This would be cumbersome in a pure BAT script, it doesn't handle date calculations very well.  But if you want to consider that I can dig one up.

It could be done with a combination of BAT and a small VBS routine for the date checking, let me know if you are interested in that.

If you wanted to deleted based on the files creation date rather than it's name, then you could just use:

forfiles /p "c:\temp" /m "????-??-??T*.wav" /d -30 /c "cmd /c del @file"

Where "c:\temp" is the folder where the files reside.

If you wanted to use the creation date instead of the modification date then you could grab this very handy free utility and get the job done that way, also with a single command line.

• Horst Schaeffer's Software Pages
• Delage32

---

»bp

testing each one!  brb

David, is that a VB script or something else?

David, is that a VB script or something else?

Looks like Powershell.

---

»bp

David, I get an error on yours.

Exception calling "Substring" with "2" argument(s): "Index and length must refer to a location within the string.
Parameter name: length"
At S:\David.ps1:9 char:9
+     if ($tokeepdate -gt  $file.Name.Substring(0,10) )
+         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : ArgumentOutOfRangeException

#>
$path = "S:\David"
$date = get-date
$maxdays = 200
$tokeepdate = $date.AddDays(-1 * $maxdays).ToString("yyyy-MM-dd")
$files = Get-ChildItem -Path $path -Recurse
foreach($file in $files)
    {
    if ($tokeepdate -gt  $file.Name.Substring(0,10) )
        {
        Remove-Item $file.Name -WhatIf   
        }
    }

Select allOpen in new window

Thank you. Your solution was spot on!