AnsweredAssumed Answered

Problem naming exported record with get(date) in script step

Question asked by BobSchwenkler on Jun 24, 2009
Latest reply on Jun 24, 2009 by philmodjunk

Title

Problem naming exported record with get(date) in script step

Post

I'm running a script step which brings up a sequence of records and am using the "Export Records" script step. The file is being saved using the name $Path. I'm trying to build $Path as follows: "Export "&Get(CurrentTimeStamp)&".csv". I've tried various other get time and date functions and whenever I have one in the variable calculation the file export fails saying, for example: "2009 11:19:08 AM.csv" could not be created on this disk. Use a different name, make more room on the disk, unlock it or use a different disk.

 

If I remove all date functions from the calculation my export works perfectly. The other interesting thing is that the error message I'm getting shows the filename as having truncated the "Export " segment of the text I'm trying to insert in the filename.

 

I also tried building $Date and then using this variable in the $Filename calculation but this didn't work any better. 

 

Any help? 

Outcomes