Is there a way to use a batch to create monthly folders "2014-02"

Posted on 2014-02-28
Medium Priority
Last Modified: 2014-03-01
Currently, I create a monthly folder in all of our Customer's Folders. Ex: 2014-02 for February Reports.

I move all of the reports based on the Customer's Name into their folder using a batch.
Here is an example of the 2nd half of the move batch.

"\\companydirectory\abc\Reports\McDonalds\Standard Reports\2014-02"
"\\companydirectory\abc\Reports\Burger King\Standard Reports\2014-02"
"\\companydirectory\abc\Reports\Wendys\Standard Reports\2014-02"

Is there a way to have the system create the 2014-02, 2014-03, etc folders without manually going to each folder and creating one myself?
Question by:NNiicckk
  • 2
  • 2
LVL 13

Expert Comment

by:Santosh Gupta
ID: 39895680

use "MD %date:~-4,4%-%date:~4,2%" command to create the folder name by year-month format.
LVL 13

Expert Comment

by:Santosh Gupta
ID: 39895781
try this one..........

Author Comment

ID: 39896185
But is there a way to get a date folder created into each one of the Customer's folders without going to each folder manually?
LVL 43

Accepted Solution

Steve Knight earned 2000 total points
ID: 39896215
Sure.  Try this for creating a specific one you enter.  Save it as "makedirs.cmd" or something.  It runs down everything in the basedir directory then goes one level further down under that in the "lowerdir" directory and creates the folder there.

Remove the word ECHO in captials to have it actually create the directories, at the moment it will show the MD commands on the screen to make sure you are happy first.


@echo off
Set basedir=\\companydirectory\abc\Reports
Set LowerDir=Standard Reports
Set /P Create=Enter directory to create: 
If "%create%"=="" exit /b

for /f "tokens=*" %%a in ('dir /b /ad "%basedir%"') do (
  echo Working on "%%~a"
  ECHO MD "%basedir\%%~a\%lowerdir%\%create%" 2>NUL

Open in new window

LVL 43

Expert Comment

by:Steve Knight
ID: 39896853
Thanks, hope that helps then.  You can combine that of course with getting the dat automatically too if wanted.


Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If like me you are one who spends a lot of time working and scripting with cmd.exe, sometimes it is handy to be able to quickly view a calendar for a given month and year. This script will quickly do just that!  Save the code posted below to a .bat …
This article was inspired by a question here at Experts Exchange (http://www.experts-exchange.com/Software/Photos_Graphics/Images_and_Photos/Q_28629170.html). The requirements stated in that question are (1) reduce the file size of a large number of…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question