@ECHO OFF

SET ArchivePathDaily=M:\MrC
SET ArchivePathMonthly=M:\MrC\MonthEndBackups

SET DailyNumberDays=7
SET MonthlyNumberDays=180

SET ReportPath=M:\MrC

SET AgedFiles=MrCDBAging.log


FOR /F "TOKENS=1* DELIMS= " %%A IN ('DATE/T') DO SET CDATE=%%B 
FOR /F "TOKENS=1,2 eol=/ DELIMS=/ " %%A IN ('DATE/T') DO SET mm=%%B 
FOR /F "TOKENS=1,2 DELIMS=/ eol=/" %%A IN ('echo %CDATE%') DO SET dd=%%B 
FOR /F "TOKENS=2,3 DELIMS=/ " %%A IN ('echo %CDATE%') DO SET yyyy=%%B 
SET date=%date:~0,2%-%date:~3,2%-%date:~6,6%

md %ReportPath%\_%date%

echo. > %ReportPath%\_%date%\%AgedFiles% 
echo Archive Report - %DATE% - %TIME% >> %ReportPath%\_%date%\%AgedFiles% 
echo. >> %ReportPath%\_%date%\%AgedFiles%

forfiles -p %ArchivePathDaily% -m *.zip -d -%DailyNumberDays% -c "cmd /c ECHO @PATH, @FDATE - @FTIME" >> %ReportPath%\_%date%\%AgedFiles%

forfiles -p %ArchivePathMonthly% -m *.zip -d -%MonthlyNumberDays% -c "cmd /c ECHO @PATH, @FDATE - @FTIME" >> %ReportPath%\_%date%\%AgedFiles%


forfiles -p %ArchivePathDaily% -m *.zip -d -%DailyNumberDays% -c "cmd /c del /q @FILE & if @ISDIR==TRUE rd /s /q @FILE" >> %ReportPath%\_%date%\%AgedFiles%

forfiles -p %ArchivePathMonthly% -m *.zip -d -%MonthlyNumberDays% -c "cmd /c del /q @FILE & if @ISDIR==TRUE rd /s /q @FILE" >> %ReportPath%\_%date%\%AgedFiles%


rmdir /s /q %ReportPath%\_%date%