forfiles /s /m *.log /d -7

forfiles /s /m *.log /d -7 /c "cmd /c echo @path"

cd /d J:/
dir /s /b *.zip>J:/ARCHIVE_SEARCH/ZIP_LIST/old_zip_list_01.txt

cd /d J:/
for /F %%I IN (J:\ARCHIVE_SEARCH\ZIP_LIST\old_zip_list_01.txt) DO ( J:\ARCHIVE_SEARCH\unzip -o %%I *.tsv -d J:\ARCHIVE_SEARCH\tsv_query )
pause



============

06/20/2017 06:22 AM 1,268,276 20170620_180824_GT_XFR_from-TGO-to-MHPSA.zip
06/26/2017 11:28 AM 852,642 20170622_130823_GT_XFR_from-TGO-to-MHPSA.zip
06/27/2017 06:22 AM 542,801 20170627_163812_GT_XFR_from-TGO-to-MHPSA.zip
06/28/2017 06:19 AM 189,741 20170628_080836_GT_XFR_from-TGO-to-MHPSA.zip
06/29/2017 06:14 AM 669,583 20170629_163820_GT_XFR_from-TGO-to-MHPSA.zip
06/30/2017 06:17 AM 1,478,904 20170630_103803_GT_XFR_from-TGO-to-MHPSA.zip

===================

forfiles /s /m *.zip /d -3 /c "cmd /c echo @file"

"20170620_180824_GT_XFR_from-TGO-to-MHPSA.zip"
"20170622_130823_GT_XFR_from-TGO-to-MHPSA.zip"
"20170627_163812_GT_XFR_from-TGO-to-MHPSA.zip"

forfiles /s /m *.zip /d -1 /c "cmd /c echo @file"

"20170620_180824_GT_XFR_from-TGO-to-MHPSA.zip"
"20170622_130823_GT_XFR_from-TGO-to-MHPSA.zip"
"20170627_163812_GT_XFR_from-TGO-to-MHPSA.zip"
"20170628_080836_GT_XFR_from-TGO-to-MHPSA.zip"
"20170629_163820_GT_XFR_from-TGO-to-MHPSA.zip"

forfiles /s /m *.zip /d -7 /c "cmd /c echo @file"

"20170620_180824_GT_XFR_from-TGO-to-MHPSA.zip"

===================

set bkupdir=%date:~4,2%%date:~7,2%%date:~10%

set bkupdir=%date:~10%%date:~4,2%%date:~7,2%

C:\WC\TSV_Extract>

echo %bkupdir%
20170630


PowerShell $date = Get-Date; $date=$date.AddDays(-1); $date.ToString('yyyy-MM-dd')
