DOS Rename error

Hi,

I have a batch file that executes some SQL statements on a text file and then renames the file with the date...
from SL1.dat to SL12006-11-19.bak

my problem is that it doesn't rename the file with the Date... only renames it to SL1.bak

here's the dos code:

FOR /F "TOKENS=2-4 DELIMS=/ " %%F IN ('DATE /T') DO (SET TODAY=%%F%%G%%H)
REN SL1.dat SL1%TODAY%.bak

is there an error in the code? does it matter if I'm on XP and it was originally written on 2000?
what should I correct?

Thanks! I'm on a deadline... thanks!
MetDiaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
sirbountyConnect With a Mentor Commented:
Why not change it to:

ren SL1.dat sl1%date:~0,2%%date:~3,2%%date:~-4,4%.bak
0
 
sirbountyCommented:
if that fails for you - please post the results by modifying the above to:

FOR /F "TOKENS=2-4 DELIMS=/ " %%F IN ('DATE /T') DO (SET TODAY=%%F%%G%%H)
echo %today%
pause
REN SL1.dat SL1%TODAY%.bak
0
 
MetDiaAuthor Commented:
this statement works:

ren SL1.dat sl1%date:~0,2%%date:~3,2%%date:~-4,4%.bak

but it is giving me this:
sl1206-1-20.bak

instead of this:
sl12006-11-20.bak

is there a small error in the statement?


the other statement:
FOR /F "TOKENS=2-4 DELIMS=/ " %%F IN ('DATE /T') DO (SET TODAY=%%F%%G%%H)
echo %today%
pause
REN SL1.dat SL1%TODAY%.bak

does not work and doesn't rename the file properly...
the only error message is "ECHO deactivated"


I'd wrather use the first statement because it looks more simple but just need to fix the date...
0
The 14th Annual Expert Award Winners

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

 
JRockSolidCommented:
Try this :

ren SL1.dat SL1%date:~4,2%-%date:~7,2%-%date:~10,12%.bak
0
 
sirbountyCommented:
Try this from a command prompt:

echo %date%
and post the results...
0
 
JRockSolidConnect With a Mentor Commented:
Sorry i messed up  :

SL1%date:~4,2%-%date:~7,2%-%date:~10,12%.bak  gives you
SL111-20-2006.bak

SL1%date:~10,12%-%date:~4,2%-%date:~7,2%.bak  gives you
SL12006-11-20.bak
0
 
MetDiaAuthor Commented:
doesn't rename it correctly either...
it gives me SL1-1--2-.bak now...

I tried playing with the different values until I stopped on:
ren SL1.dat SL1%date:~0,10%.bak

and it works perfectly!
Thank you very much JRockSold!
0
 
sirbountyCommented:
I would've thought I'd have at least gotten an assist here...
0
 
MetDiaAuthor Commented:
so sorry sirbounty... I have no clue how to give an assist...
is there a way I can change that?
0
 
JRockSolidCommented:
Yes an assist was defanately in order
Pleasse ask the moderators to help you change it
0
 
JRockSolidCommented:
Community Support / Customer Service is here:
http://www.experts-exchange.com/Community_Support/
0
 
sirbountyCommented:
Cool - thanx.
0
 
MetDiaAuthor Commented:
Thanks guys!!
Won't do that error again!

0
 
JRockSolidCommented:
Thank you MetDia
and you as well sir
0
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.

All Courses

From novice to tech pro — start learning today.