Create a folder that includes date in the name 2

[ljg]

Hoping someone can assist me. I'm looking for a way to create a folder using vbscript that includes the date in the name. I have the (very simple) script below, and it works as-is, but i want the destination folder to be g:\backups_date\ and I can't figure it out. Any help would be greatly appreciated -- I'm missing something. Can anyone tell me how to create the destination folder including the DATE?

*******************************
Option Explicit

dim destination
dim sourcefolder

destination = "g:\backups\"
sourcefolder = "c:\temp"

Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFolder = objFSO.CreateFolder(destination)
objFSO.CopyFolder sourcefolder, destination

wscript.echo "Done copying files"

******************************

Thx,
LJG

 

[PHV]

A starting point:
destination = "g:\backups_" & (10000*Year(Date)+100*Month(Date)+Day(Date)) & "\"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ljg]

PHV that was exactly what I was looking for. I had the general idea but could NOT get the syntax right. You made my day -- thanks!!

 

[withanh]

That's a cool way to do it PHV. You get a star from me as well.

Thanks!

h

 

[ljg]

Check THIS one out -- a coworker suggested this:

destination = "g:\_backups_" & Year(Date) & "-" & Month(Date) & "-" & Day(Date)

which gives me \_backups_2009-2-3\ (remove the dashes if you like)