How to copy files and paste in folder by creating a current date in batch script

Question

I have a bunch of Excel Workbooks that update periodically. I want to copy these files every Sunday to the folder created with current date in the name (e.g. Workbooks-28.06.2017). I have written a batch script but it is not working.

What am I doing wrong?

Code:

@echo OFF

xcopy /s C:\Users\rerraboina\Desktop\tracker automation\Consolidation\test dynamic

for /f "skip=1" %%d in ('wmic os get localdatetime') do if not defined mydate set mydate=%%d
md %mydate:~0,8%

You should enclose the paths with spaces in double quotations. — Azeem
– Azeem, Commented Jun 28, 2017 at 7:24
@Azeem thank you, it is creating only folder with the date but it is not copying the files from source folder to the date folder. Please help — AayushmanR
– AayushmanR, Commented Jun 28, 2017 at 7:30
You are welcome! You have to accept the edit to show it. BTW, you are xcopying before creating the folder and the second parameter destination is missing e.g. xcopy source destination. I've posted my answer. You can go through it and then compare it with yours to understand what is happening here. — Azeem
– Azeem, Commented Jun 28, 2017 at 7:41

Azeem · Accepted Answer · 2017-06-28 09:41:31Z

1

Here's an example:

archive.bat

@ ECHO OFF

PUSHD %~dp0

FOR /f "skip=1" %%d IN ('WMIC OS get LocalDateTime') DO IF NOT DEFINED myDate SET myDate=%%d
SET archiveDirName=Workbooks-%myDate:~0,8%
MD %archiveDirName%

XCOPY /S /I /Y "Excel Workbooks" %archiveDirName%\

POPD

"Excel Workbooks" is an example folder which contains multiple subfolders having on *.xlsx file in each.

edited Jun 28, 2017 at 9:41

answered Jun 28, 2017 at 7:38

Azeem

15.1k4 gold badges36 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

AayushmanR Over a year ago

It created only folder as "Workbooks-2017062" but files are not transferred. I have tried with and without replacing "Excel Workbooks" with my path, but its not working.

Azeem Over a year ago

@AayushmanR: Actually, that was an example. I've used Excel Workbooks in my code. You have to put the folder name with full path in quotations. If that doesn't work, then post your code here with error.

AayushmanR Over a year ago

@ ECHO OFF FOR /f "skip=1" %%d IN ('WMIC OS get LocalDateTime') DO IF NOT DEFINED mydate set mydate=%%d md %mydate:~0,8% SET archiveDirName="Workbooks-%myDate:~0,8%" MD %archiveDirName% XCOPY /s "C:\Users\rerraboina\Desktop\tracker automation\Production Launches Cosolidation 2 june" %archiveDirName%

AayushmanR Over a year ago

I have posted the code in the above comment. The only error is that it is creating the folder with current date but the files are transferring from source path to the created date fodler.

Azeem Over a year ago

@AayushmanR: Yes. It copies the files from all the sources to the newly created folder. Do you want to copy each file along with its own folder?

|

Collectives™ on Stack Overflow

How to copy files and paste in folder by creating a current date in batch script

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related