Script Library - Windows Batch - Generic Date Value

Script Library is my collection of reusable component as plugable script to get DATE value to be used in Windows Batch Scripting.

The scripts have the same usage but is written using different approach depending your needs:

1. Script 1: Batch command [Date /T]
2. Script 2: VBScript
3. Script 3: Powershell

Have a great day


How To Include In Script

1. You can either embed the script block in your own script.

2. You can save the script in the file and include "CALL" command to activate.
     eg. CALL YLNotes_ScriptLibrary_Windows_GenericDateValue_0001.cmd



Date Value Usage

The Date Value is prefix with "d' which refers to date.
The detail reference of date usage are shown below table

-------------------------------------------- Day Usage -------------------------------------------- Single Digit dD = 1 Two Digits dDD = 01 Weekday Short Name dDDD = Thu Weekday Full Name dDDDD = Thursday -------------------------------------------- -------------------------------------------- Month Usage -------------------------------------------- Single Digit dM = 1 Two Digits dMM = 01 Month Short Name dMMM = Jan Month Full Name dMMMM = January -------------------------------------------- -------------------------------------------- Year Usage -------------------------------------------- Two Digits dYY = 15 Four Digits dYYYY = 2015 --------------------------------------------

Example of Date Value in Windows Batch Scripting:

1. To generate date timestamp "YYYYMMDD"
     ECHO %dYYYY%%dMM%%dDD%

2. To generate Today Date with format "dd-MM-YYYY" like "01-Mar-2014"
     ECHO %dDD%-%dMMM%-%dYYYY%

3. To generate Today Date with format "dd/MM/YYYY" like "01/03/2014"
     ECHO %dDD%/%dMM%/%dYYYY%

4. To generate Today Date with format "d/M/YY" like "1/3/14"
     ECHO %dD%/%dM%/%dYY%

Script Library

Date Value Script #0001: YLNotes_ScriptLibrary_Windows_GenericDateValue_0001.cmd Date Value: Batch Command

@ECHO OFF ECHO ================================================================== ECHO YL Library : Script Library Windows for Generic Date Value #0001 ECHO Description: Date Value [Date /T] ECHO Author : Zhang Yunlong ECHO Blog : ylnotes.blogspot.com ECHO Filename : YLNotes_ScriptLibrary_Windows_GenericDateValue_0001.cmd ECHO ================================================================== SetLocal EnableDelayedExpansion FOR /F "tokens=2 skip=1 delims=()" %%a in ('DATE ^< NUL') DO ( SET DATEFORMAT=%%a FOR /F "tokens=1-2 delims= " %%b in ('DATE /T') DO ( IF "%%c" EQU "" ( SET dDDD= SET DateValueString=%%b ) ELSE ( IF "%DATE:~3,1%" EQU "." ( SET dDDD=%%b SET DateValueString=%%c ) ELSE ( IF "%DATE:~3,1%" EQU " " ( SET dDDD=%%b SET DateValueString=%%c ) ELSE ( SET dDDD=%%c SET DateValueString=%%b ) ) ) ) ) FOR /F "tokens=1-3 delims=/.-" %%d IN ("%DATEFORMAT%") DO ( FOR /F "tokens=1-3 delims=/.-" %%g IN ("%DateValueString%") DO ( SET %%d=%%g SET %%e=%%h SET %%f=%%i ) ) SET dDD=%dd% SET dMM=%mm% SET dYYYY=%yy% IF "%dDD:~0,1%" EQU "0" (SET dD=%dDD:~1,1%) ELSE (SET dD=%dDD%) IF "%dMM:~0,1%" EQU "0" (SET dM=%dMM:~1,1%) ELSE (SET dM=%dMM%) SET dYY=%dYYYY:~2,2% SET WEEKDAY_NAMES=Monday Tuesday Wednesday Thursday Friday Saturday Sunday FOR %%a IN (%WEEKDAY_NAMES%) DO ( SET WEEKDAY_VALUE=%%a IF "!dDDD!" EQU "!WEEKDAY_VALUE:~0,3!" SET dDDDD=!WEEKDAY_VALUE! && GOTO WEEKDAY_NAME_MATCH ) :WEEKDAY_NAME_MATCH SET MONTH_NAMES=01January 02Febuary 03March 04April 05May 06June 07July 08August 09September 10October 11November 12December FOR %%a IN (%MONTH_NAMES%) DO ( SET MONTH_VALUE=%%a IF "!dMM!" EQU "!MONTH_VALUE:~0,2!" ( SET dMMM=!MONTH_VALUE:~2,3! SET dMMMM=!MONTH_VALUE:~2,9! GOTO MONTH_NAME_MATCH ) ) :MONTH_NAME_MATCH

Date Value Script #0002: YLNotes_ScriptLibrary_Windows_GenericDateValue_0002.cmd Date Value: Batch [VBScript]

SET vbsDateCommand=%TEMP%\vbsDateCommand.vbs > %vbsDateCommand% ECHO Dim dtTodayDate, vbSunday : dtTodayDate = Now >> %vbsDateCommand% ECHO Dim arrWeekDayName : arrWeekDayName = Array("Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday") >> %vbsDateCommand% ECHO. >> %vbsDateCommand% ECHO Function GetDateValue(strDateValueSymbol) >> %vbsDateCommand% ECHO Select Case (Trim(strDateValueSymbol)) >> %vbsDateCommand% ECHO Case "dD" >> %vbsDateCommand% ECHO GetDateValue = DatePart("d", dtTodayDate, vbSunday) >> %vbsDateCommand% ECHO Case "dDD" >> %vbsDateCommand% ECHO GetDateValue = Right("0" ^& DatePart("d", dtTodayDate, vbSunday), 2) >> %vbsDateCommand% ECHO Case "dDDD" >> %vbsDateCommand% ECHO GetDateValue = Left(arrWeekDayName(DatePart("w", dtTodayDate, vbSunday) - 1), 3) >> %vbsDateCommand% ECHO Case "dDDDD" >> %vbsDateCommand% ECHO GetDateValue = arrWeekDayName(DatePart("w", dtTodayDate, vbSunday) - 1) >> %vbsDateCommand% ECHO Case "dM" >> %vbsDateCommand% ECHO GetDateValue = DatePart("m", dtTodayDate, vbSunday) >> %vbsDateCommand% ECHO Case "dMM" >> %vbsDateCommand% ECHO GetDateValue = Right("0" ^& DatePart("m", dtTodayDate, vbSunday), 2) >> %vbsDateCommand% ECHO Case "dMMM" >> %vbsDateCommand% ECHO GetDateValue = MonthName(DatePart("m", dtTodayDate, vbSunday),True) >> %vbsDateCommand% ECHO Case "dMMMM" >> %vbsDateCommand% ECHO GetDateValue = MonthName(DatePart("m", dtTodayDate, vbSunday),False) >> %vbsDateCommand% ECHO Case "dYY" >> %vbsDateCommand% ECHO GetDateValue = Right(DatePart("yyyy", dtTodayDate, vbSunday), 2) >> %vbsDateCommand% ECHO Case "dYYYY" >> %vbsDateCommand% ECHO GetDateValue = DatePart("yyyy", dtTodayDate, vbSunday) >> %vbsDateCommand% ECHO End Select >> %vbsDateCommand% ECHO End Function >> %vbsDateCommand% ECHO. >> %vbsDateCommand% ECHO WScript.Echo GetDateValue("dD") ^& "-" ^& _ >> %vbsDateCommand% ECHO GetDateValue("dDD") ^& "-" ^& _ >> %vbsDateCommand% ECHO GetDateValue("dDDD") ^& "-" ^& _ >> %vbsDateCommand% ECHO GetDateValue("dDDDD") ^& "-" ^& _ >> %vbsDateCommand% ECHO GetDateValue("dM") ^& "-" ^& _ >> %vbsDateCommand% ECHO GetDateValue("dMM") ^& "-" ^& _ >> %vbsDateCommand% ECHO GetDateValue("dMMM") ^& "-" ^& _ >> %vbsDateCommand% ECHO GetDateValue("dMMMM") ^& "-" ^& _ >> %vbsDateCommand% ECHO GetDateValue("dYY") ^& "-" ^& _ >> %vbsDateCommand% ECHO GetDateValue("dYYYY") FOR /F "tokens=1-10 delims=-" %%a IN ('CSCRIPT //NoLogo %vbsDateCommand%') DO ( SET dD=%%a SET dDD=%%b SET dDDD=%%c SET dDDDD=%%d SET dM=%%e SET dMM=%%f SET dMMM=%%g SET dMMMM=%%h SET dYY=%%i SET dYYYY=%%j ) IF EXIST "%vbsDateCommand%" DEL /Q /F "%vbsDateCommand%"

Date Value Script #0003: YLNotes_ScriptLibrary_Windows_GenericDateValue_0003.cmd Date Value: Batch [Powershell]

@ECHO OFF ECHO ================================================================== ECHO YL Library : Script Library Windows for Generic Date Value #0003 ECHO Description: Date Value [Powershell] ECHO Author : Zhang Yunlong ECHO Blog : ylnotes.blogspot.com ECHO Filename : YLNotes_ScriptLibrary_Windows_GenericDateValue_0003.cmd ECHO ================================================================== FOR /F "tokens=1-20 delims=-" %%a in ('PowerShell.exe Get-Date -format "d-dd-ddd-dddd-M-MM-MMM-MMMM-yy-yyyy"') DO ( SET dD=%%a SET dDD=%%b SET dDDD=%%c SET dDDDD=%%d SET dM=%%e SET dMM=%%f SET dMMM=%%g SET dMMMM=%%h SET dYY=%%i SET dYYYY=%%j )