How to delete the old excel file from a folder

@HeartCatcher

  1. Use For each folder in folder activity.
  2. mention the folder path which contains ModmedRejection24092022 and more folders
  3. Assign Days=2 , because of filter last 2 days and days should Integer
  4. Use assign and separate the date from the folder by
FolderDateString=System.Text.RegularExpressions.Regex.Match(CurrentFolder.Name,"\d+").ToString.Trim

FolderdateString was the variable type of string
  1. Convert it to date format
FolderDate=DateTime.ParseExact(FolderDateString,"ddMMyyyy",System.Globalization.CultureInfo.InvariantCulture)

where folderDate was variable type of  System.DateTime
  1. Use If condition to filter folder
FolderDate<=Now.Date.AddDays(-BeforeDays)
  1. Then sequence use Delete Folder
CurrentFolder.ToString

image



image