DISQUS

Tech-Recipes: Windows Batch File (.bat) to get current date in MMDDYYYY format. | Computer programming | Tech-Recipes

  • Anonymous · 4 years ago
    Here is a one liner
    <ul id="quote">For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set date=%%a-%%b-%%c)</ul>

    There may still be value in the first example it you need to access the seperate mm,dd,yyyy values but this works great for me.
  • Anonymous · 4 years ago
    <ul id="quote"><h6>wattpuppy wrote:</h6>Here is a one liner
    </ul><ul id="quote">For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set date=%%a-%%b-%%c)</ul>

    There may still be value in the first example it you need to access the seperate mm,dd,yyyy values but this works great for me.

    hmm.. I tried your oneliner and only could get the day and the year.. I was missing the month.. I tried playing with the tokens and changing it to 1-4, but then I got Tue 08-16-2004 ..

    the first iteration on the initial page added an extra space which I didn't like.. thanks for the help!
  • Anonymous · 4 years ago
    I actually fiddled with it and made it two lines.. but it's working..

    here it is..

    FOR /F "TOKENS=1* DELIMS= " %%A IN ('DATE/T') DO SET CDATE=%%B
    For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set date=%%a%%b%%c)
  • Anonymous · 4 years ago
    Wierd! I currently use the exact code I sent posted to generate mm-dd-yyyy on a log file. What OS are you using? I'm running this on both Winxp and Win2000 Server.
  • Anonymous · 4 years ago
    win 2003 server .. I can't see why there would be a difference...
  • Subhash · 3 years ago
    Hi,

    Idea about getting the current date time in required format is good. I wanted to know how to subtract the required days from the current date.

    Like current date is 11/18/2005
    required date is 11/15/2005 i.e., subtract 3 days from current date.

    Then use that date in our script.
  • Anonymous · 3 years ago
    Hi Subhash

    Getting calculation of date is no easy task.
    What O/S are you using.

    It's inportant because, "echo %Date%" or date /t would produce
    different results on different O/S and date formats ie.

    WinXP English Date 01/12/2005
    WinXP American Date 12/01/2005

    Win 2000 the same but adds the Weekday Tue 01/08/2005
  • mahen · 3 years ago
    Hi,

    You can try the below. it works in XP.

    FOR /F "TOKENS=1,2 DELIMS=/ " %%A IN ('DATE /T') DO SET mm=%%B
    FOR /F "TOKENS=2,3 DELIMS=/ " %%A IN ('DATE /T') DO SET dd=%%B
    FOR /F "TOKENS=3* DELIMS=/ " %%A IN ('DATE /T') DO SET yyyy=%%B

    set /A dd=%dd%-3

    set Pdate=%mm%/%dd%/%yyyy%
    echo %Pdate%


    rgds
    Mahen
  • pbv kumar · 1 year ago
    it works fantastic bu tmy problem is in format i want the date should be form 1 to 9 will be 01 ,02,03 & 09 like . kindly giv eme the solutions
  • davak · 3 years ago
    <ul id="quote"><h6>Subhash wrote:</h6>Hi,

    Idea about getting the current date time in required format is good. I wanted to know how to subtract the required days from the current date.

    Like current date is 11/18/2005
    required date is 11/15/2005 i.e., subtract 3 days from current date.

    Then use that date in our script.</ul>

    Date Calculation In Batch Files XP/2000:
    http://www.tech-recipes.com/batch_file_programm...
  • Anonymous · 2 years ago
    Seamonkey 420,

    I am trying to modify your code so it sets a variable for date in the format YYMMDD with no spaces. I tried to make the mods, but I just don't have the knowledge nor the time to figure this out.

    Can you assist?

    dklock
  • Anonymous · 2 years ago
    Try this.


    for /f "tokens=1,2" %%u in ('date /t') do set d=%%v
    for /f "tokens=1" %%u in ('time /t') do set t=%%u
    if "%t:~1,1%"==":" set t=0%t%
    rem set timestr=%d:~6,4%%d:~3,2%%d:~0,2%%t:~0,2%%t:~3,2%
    set datestr=%d:~6,4%%d:~0,2%%d:~3,2%
    set timestr=%t:~0,2%%t:~3,2%

    @echo %datestr%-%timestr%
    @echo %datestr%
    @echo %timestr%


    SparkByte
  • Anonymous · 1 year ago
    i am working on a windows batch script that creates a zip file and adds the date to the file name, this works great for a full backup. I want to be able to set the initial date that the incremental backup begins, and then count up three days, and append the updated date to the zip file name.

    This is what i use to create the date:
    Set DD_MM_YYYY=%DATE:~4,2%_%DATE:~7,2%_%DATE:~10,4%

    then create file and add it to name as so:
    7a u -tzip e:backupincremental_%DD_MM_YYYY%.zip

    I would like to set the initial date for the file on lets say Monday 12_10_2007 then for Tues, Wed, and Thurs, append the file name to something like:
    incremental_%DD_MM_YYYY%_%Tues%.zip
    incremental_%DD_MM_YYYY%_%Wed%.zip
    incremental_%DD_MM_YYYY%_%Thurs%.zip

    Is it possible to set tues, wed, thurs as variables then script the rename of the file to reflect the new days?

    I guess I'm too new at this and could use some advice.

    Thanks,
  • TonyCH · 1 year ago
    The 2nd line should have: echo %CDATE%
    instead of: DATE/T
  • hi · 11 months ago
    this does not work
  • XJ Moonen · 10 months ago
    Perhaps you should try this

    :: script for datestring in yyyymmdd format
    :: XJ Moonen Netherlands


    for /f "tokens=1,2" %%u in ('date /t') do set d=%%v
    for /f "tokens=1" %%u in ('time /t') do set t=%%u

    if "%t:~1,1%"==":" set t=0%t%

    set datestr=%d:~6,4%%d:~3,2%%d:~0,2%
    set y=%d:~6,4%
    set m=%d:~3,2%
    set d=%d:~0,2%

    :: test if month < 10 if yes then add a leading zero
    if /i %m% LSS 10 set m=0%m%

    :: test if day < 10 if yes then add a leading zero
    if /i %d% LSS 10 set d=0%d%

    set ymd=%y%%m%%d%

    ::set the actual timestring ie 2034
    set timestr=%t:~0,2%%t:~3,2%

    :: set the filename
    set fname=Filename%ymd%_%timestr%

    :: show the filename
    echo %fname%
    c:\windows\system32\sleep.exe 10
  • Ryan · 9 months ago
    why not just do this:

    set mydate=%date:~4,2%%date:~7,2%%date:~10,4%
  • Hersch · 9 months ago
    Ryan, I love it, it is great one line no trickery with files etc. I expanded it further my requirements.

    echo Get the current date and time in YYYY-MM-DD-HH-MM-SS format
    SET isodt=%date:~10,4%-%date:~7,2%-%date:~4,2%-%time:~0,2%-%time:~3,2%-%time:~6,2%
    echo %isodt%

    Thanks a million
  • mike · 7 months ago
    genius!, simple, elegant! thanks!
  • girija · 2 months ago
    THANKS I GOT MY SOLUTION FROM THIS SITE, THANKS RYAN
  • Rakesh Bhangre · 9 months ago
    like my file in E drive - 06022009.DMP so how can copy this file in CD Drive using Batch file. my batch file is :-
    @echo off
    cls
    echo Copying started at %date% %time%
    xcopy "E:\%date%.DMP" "C:\Documents and Settings\Hp1\Local Settings\Application Data\Microsoft\CD Burning\BACKUP\*.*" /s /e /h /c /d /i /y
    xcopy "C:\Documents and Settings\Hp1\Local Settings\Application Data\Microsoft\CD Burning\BACKUP\*.*" "G:\BACKUP\*.*"
    PAUSE
    explorer g:
  • Marcus · 8 months ago
    Perfect, exactly what i wanted, thanks for saving me 2 hours !
  • rvsdi · 8 months ago
    how to save file with filename+current date
    ex : myfile20090210
  • leif · 8 months ago
    not the best at this yet dont even realy know what half what i posted mean but i just got it working with the Filename_"%PDATE%". if you dont want a gap inbetween file and date do Filename"%PDATE%". hope it helps.

    FOR /F "TOKENS=1,2 DELIMS=/ " %%A IN ('DATE /T') DO SET mm=%%B
    FOR /F "TOKENS=2,3 DELIMS=/ " %%A IN ('DATE /T') DO SET dd=%%B
    FOR /F "TOKENS=3* DELIMS=/ " %%A IN ('DATE /T') DO SET yyyy=%%B

    set /A dd=%dd%

    set Pdate=%yyyy%_%mm%_%dd%
    echo %Pdate%

    mkdir C:\MYFILE_"%PDATE%"\
  • Fuad · 6 months ago
    Okey
    that helps
  • Some User · 6 months ago
    For programmers in the USA, use THIS script instead, otherwise it won't work with the standard Windows US MM/DD/YYYY format.

    @Echo Off
    Set YYYY-MM-DD=%DATE:~6,4%-%DATE:~0,2%-%DATE:~3,2%
  • Chris Felpel · 6 months ago
    Many thanks. I started to write my own then quickly remembered writing bat files requires a fine mix of science and art with a dash of experence.
  • James Lubuag · 6 months ago
    how can i combine the date and time to create a file name. please advise



    echo %date:~10,4%%date:~7,2%%date:~4,2%

    ren d:\temp\log.pdf Survey%date:~10,4%%date:~7,2%%date:~4,2%.pdf


    pause

    for /f "tokens=1-5 delims=:" %%d in ("%time%") do rename "hope.pdf" %%d-%%e.pdf
    pause
  • FP · 5 months ago
    Or you can use %date% and parse it later in your script.
  • Rarsa · 5 months ago
    I had been using a method similar to yours but recently I found one that is even simpler:

    The %DATE% AND %TIME% variables contain the formated date and time so you an just extract the substrings using regular variable syntax

    set _DATETIME=%DATE:~10,4%%DATE:~4,2%%DATE:~7,2%%TIME:~0,2%%TIME:~3,2%%TIME:~6,2%

    In my case

    %DATE% contains "Tue 05/26/2009"
    so %DATE:~10,4% means to extract a substring 4 characters long starting from character 10

    If you weren't aware of that way of handling substrings for any variables, now you know.

    If you have a different default date format than mine you will have to adapt the parameters
  • Trent Nelson · 5 months ago
    Here's what I use. It queries the registry first to figure out what format the date is going to be returned in. It currently supports UK and US locales (as that's all I need to support at the moment). Trivial to extend it to support others.

    @echo off
    goto test

    :get_date_yyyymmdd
    setlocal enableextensions enabledelayedexpansion
    set _RV=
    set _ERR=0
    set _CMD=reg query "HKCU\Control Panel\International" /v sShortDate
    for /f "usebackq skip=2 tokens=3,* delims= " %%i in (`%_CMD%`) do (
    rem Amsterdam/Houston servers:
    rem Short date format (%%i): M/d/yyyy
    rem Sample %DATE%: Thu 05/29/2009
    rem London servers:
    rem Short date format (%%i): dd/MM/yyyy
    rem Sample %DATE%: 29/05/2009
    set D=!DATE!
    echo i: %%i
    echo D: !D!
    if "%%i"=="M/d/yyyy" (
    rem I'm assuming the day abbreviation will always be three chars
    rem (so we account for four in total, including the space). So
    rem far, I can attest that this is definitely the case on Wed &
    rem Thu ;-)
    set yyyy=!D:~-4!
    set mm=!D:~-10,-8!
    set dd=!D:~-7,-5!
    ) else if "%%i"=="dd/MM/yyyy" (
    set yyyy=!D:~-4!
    set mm=!D:~-7,-5!
    set dd=!D:~-10,-8!
    ) else (
    echo fatal: I don't understand this system's date format (%%i^)
    set _ERR=1
    )
    )
    set _RETVAL=!yyyy!!mm!!dd!
    endlocal & set _YYYYMMDD=%_RETVAL% & set _ERROR=%_ERR%
    exit /b %_ERROR%

    :test
    call :get_date_yyyymmdd
    echo formatted date: %_YYYYMMDD%
  • marcwentink · 3 months ago
    Thanks Trent that is what I want: getting day month and year INDEPENDANT of the format used. I am going to study this.
  • dan · 5 months ago
    Thanks guys... I really didn't have time to figure this out myself
    I was going to recreate xset32 for win64 in c++ or PERL, but this is much easier.
  • Ben Personick · 4 months ago
    Erms, that IS pretty old school, try:

    Set TDate=%date:~10,4%%date:~4,2%%date:~7,2%


    1 line = better

    =D

    PS. Also it's bad form to use a variable with the same name as a command, so, don't do that. =P


    Peace,

    -B
  • marcwentink · 3 months ago
    May this is usefull, especially since it is an example how to get all kinds of everything INDEPENDENT of the current language locale and date format settings using the Windows Scripting Host

    ::::::::::::::::::::::::::::::::::::::::::::::::::::::::
    ::
    :: This uses Windows Scripting Host to set variables
    :: to the current date/time/day/day_number
    :: for Win9x/ME/NT/W2K/XP etc
    :: Thanks go to Todd Vargo for his scripting
    ::::::::::::::::::::::::::::::::::::::::::::::::::::::::
    @echo off
    set TmpFile="%temp%.\tmp.vbs"
    echo> %TmpFile% n=Now
    echo>>%TmpFile% With WScript
    echo>>%TmpFile% .Echo "set year=" + CStr(Year(n))
    echo>>%TmpFile% .Echo "set yr=" + Right(Year(n),2)
    echo>>%TmpFile% .Echo "set month="+ Right(100+Month(n),2)
    echo>>%TmpFile% .Echo "set day=" + Right(100+Day(n),2)
    echo>>%TmpFile% .Echo "set hour=" + Right(100+Hour(n),2)
    echo>>%TmpFile% .Echo "set min=" + Right(100+Minute(n),2)
    echo>>%TmpFile% .Echo "set sec=" + Right(100+Second(n),2)
    echo>>%TmpFile% .Echo "set dow=" + WeekDayName(Weekday(n),1)
    echo>>%TmpFile% .Echo "set dow2=" + WeekDayName(Weekday(n))
    echo>>%TmpFile% .Echo "set iso=" + CStr(1 + Int(n-2) mod 7)
    echo>>%TmpFile% .Echo "set iso2=" + CStr(Weekday(n,2))
    echo>>%TmpFile% End With
    cscript //nologo "%temp%.\tmp.vbs" > "%temp%.\tmp.bat"
    call "%temp%.\tmp.bat"
    del "%temp%.\tmp.bat"
    del %TmpFile%
    set TmpFile=
    set stamp=%year%-%month%-%day%_%hour%.%min%.%sec%

    echo The year (YYyy) is "%year%"
    echo The year (yy) is "%yr%"
    echo The month is "%month%"
    echo The day (%dow%) is "%day%"
    echo The full weekday name is "%dow2%"
    echo.
    echo ISO 8601 Day-Of-Week number is "%iso%"
    echo.
    echo The hour is "%hour%"
    echo The minute is "%min%"
    echo The second is "%sec%"
    echo.

    echo The date and time stamp is "%stamp%"
    echo.
    echo time (hhmmss) (%hour%%min%%sec%)
    echo.
    echo date A (yyyymmdd) (%year%%month%%day%)
    echo date B (mmddyyyy) (%month%%day%%year%)
    echo date C (ddmmyyyy) (%day%%month%%year%)
    echo.
    echo date D [yymmdd] [%yr%%month%%day%]
    echo date E [mmddyy] [%month%%day%%yr%]
    echo date F [ddmmyy] [%day%%month%%yr%]
    :: datetime.bat
    ::::::::::::::::::::::::::::::::::::::::::::::::::::::::
  • ashmo · 2 months ago
    I have read though all of these posts and still can't seem to figure out how to make a directory (folder) with the current date in the following format 09_08_13 (yy_mm_dd). Can anyone help me with this?
  • ahopici · 2 months ago
    The solution using VB script is awesome.
    Eventually, extracting date is independent of regional setting on each particular computer.

    Thank you, marcwentink.
  • ASh · 2 months ago
    how can I create a file.txt containing the name of a file with the date of yesterday?

    for example:

    I have to create a file named:
    script_ftp.txt -> within this file must be:

    get TCFILE720/TCCFASIE.F(dated yesterday) S: \ files \ TCCFASIE.F(dated yesterday)

    how can I create a file.txt containing the name of a file with the date of yesterday?

    for example:

    I have to create a file named:
    script_ftp.txt -> within this file must be:

    get TCFILE720/TCCFASIE.F20090825 S: \ files \ TCCFASIE.F20090825.dat
  • foAudits · 2 months ago
    Thank you seamonkey420,

    This is just what I was looking for.

    ~Bill
  • David Thomas · 2 months ago
    one liner (YYYYMMDD): %date:~10,4%%date:~4,2%%date:~7,2%
    output: 20090830
  • Chris Hackett · 1 month ago
    Thanks, this is exactly what I was looking for!