Problem naming exported record with get(date) in script step
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.