Digital Workshop

Here is a small script I have been struggling with:
-----------------------------
var fileDate = new Date()
var currDate = fileDate.getDate()
var currMonth = fileDate.getMonth()
var currYear = fileDate.getFullYear()
var filename= currDate + currMonth + currYear


if (FileExists( data + "\\review.mdb" ))

{
CopyFile( data + "\\review.mdb",data +"\\backup\\filename.mdb")
DeleteFile(data + "\\review.mdb")
}
---------------------------------
The syntax to pass the file name variable does not work . I can find no reference as to how the variable should be shown in a file address. I could do most of this without scripting but I needed to check for the existence a file before taking action.

Also passing date information into one variable ends up with it being added so i have got that wrong too! However, any advice on first part would be greatly appreciated.

Jeremy

Not sure I understand what's wrong.

The syntax for the FileExist command is fine and assuming the path in data is correctly formed, then it should work.

will show the parameter as hard code.

Mack

Please don't bother with this one!After endless experimentation I have now made it work...

var fileDate = new Date()
var currDate = fileDate.getDate()
var currMonth = fileDate.getMonth()
var currYear = fileDate.getFullYear()
var filename= currDate +" "+ currMonth +" "+ currYear+" "+count

if (FileExists( data + "\\review.mdb" ))
{
CopyFile( data + "\\review.mdb",data +"\\backup\\"+filename+".mdb")

DeleteFile(data + "\\review.mdb")
}
It was obvious really and I will continue to move databases about in spite of severe warnings from DW support staff.

Jeremy