Parsing Date in a Batch File

re: Parsing Date in a Batch File

Mejner — Tue, 05 Jan 2010 09:09:31 GMT

And a Swedish verison:

@For /F "tokens=3,2,1 delims=- " %%A in ('Date /t') do @(

Set Day=%%A

Set Month=%%B

Set Year=%%C

)

re: Parsing Date in a Batch File

Richard Quadling — Tue, 01 Dec 2009 10:06:08 GMT

Though one issue exists if a user is using long date parts for their short date (set via the regional settings in the control panel).

As long as the parts are dd, mm and yyyy and separated by one of '-./' then all should be well. The order is all handled - yyyy-mm-dd, mm-dd-yyyy, dd-mm-yyyy, etc.

re: Parsing Date in a Batch File

Richard Quadling — Tue, 01 Dec 2009 10:00:42 GMT

This is what I use. Works for all our servers and workstations.

@ECHO OFF

FOR /F "tokens=1-6 delims=.-/: " %%A IN ("%DATE% %TIME%") DO (

FOR /F "tokens=2-4 skip=1 delims=(.-/)" %%G IN ('VER^|DATE') DO (

SET %%G=%%A

SET %%H=%%B

SET %%I=%%C

SET HH=%%D

SET II=%%E

SET SS=%%F

)

ECHO YY = %YY%

ECHO MM = %MM%

ECHO DD = %DD%

ECHO HH = %HH%

ECHO II = %II%

ECHO SS = %SS%

One issue is DST. There seems to be no way to deal with this from the command prompt.

re: Parsing Date in a Batch File

Buffme — Wed, 14 Oct 2009 23:22:40 GMT

For /f "tokens=1,2,3,4,5 delims=/. " %%a in ('date/T') do set CDate=%%d-%%b-%%c

@echo data = %CDate%

This is in the Year-Month-Day that is most common now days

re: Parsing Date in a Batch File

plowther — Fri, 12 Jun 2009 19:02:17 GMT

Files in windows exp can't contain the "/" character, it causes issues.

re: Parsing Date in a Batch File

cbryant — Wed, 10 Jun 2009 04:22:47 GMT

Hi, I need to change to date format of a file xxxxx.txt2009-05-10

xxxxx.txt2009/05/10

Is there an easy wasy to do this?

re: Parsing Date in a Batch File

Chandra — Tue, 09 Jun 2009 12:11:47 GMT

Very very useful :) Thanks a lot.

re: Parsing Date in a Batch File

toufiqkm — Fri, 08 May 2009 15:08:34 GMT

I am using Windows XP Pro... whoever gave the last solution deserves a big thanks.. I was looking for this code... but you made a little mistake.. coz Win XP uses this format Day mm-dd-yyyy the actual coding should be :

@echo off

SET Month=%DATE:~4,2%

if %Month%==01 set Month=JAN

if %Month%==02 set Month=FEB

if %Month%==03 set Month=MAR

if %Month%==04 set Month=APR

if %Month%==05 set Month=MAY

if %Month%==06 set Month=JUN

if %Month%==07 set Month=JUL

if %Month%==08 set Month=AUG

if %Month%==09 set Month=SEP

if %Month%==10 set Month=OCT

if %Month%==11 set Month=NOV

if %Month%==12 set Month=DEC

echo %Month%

re: Parsing Date in a Batch File

iceblitz — Tue, 14 Apr 2009 07:55:17 GMT

Fantastic. this is exactly what i needed to create a series of backups.

Thanx a lot.

re: Parsing Date in a Batch File

Joel — Wed, 18 Feb 2009 12:38:58 GMT

Thanks - this post is really useful. There may well be a better way, but the following will convert the month to a Mid name:

@echo off

SET Month=%DATE:~3,2%

if %Month%==01 set Month=JAN

if %Month%==02 set Month=FEB

if %Month%==03 set Month=MAR

if %Month%==04 set Month=APR

if %Month%==05 set Month=MAY

if %Month%==06 set Month=JUN

if %Month%==07 set Month=JUL

if %Month%==08 set Month=AUG

if %Month%==09 set Month=SEP

if %Month%==10 set Month=OCT

if %Month%==11 set Month=NOV

if %Month%==12 set Month=DEC

echo %Month%