4 Replies Latest reply on Jun 24, 2009 12:37 PM by philmodjunk

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

    BobSchwenkler

      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?