2 Replies Latest reply on Mar 5, 2015 5:39 AM by sccardais

    Include Date range in variable for export path to Excel

    sccardais

      Title

      Include Date range in variable for export path to Excel

      Post

      I want to include a date range in the filename of an export to Excel.

      EXAMPLE: New Users 2/15/15 - 3/4/2015.xls

      A Custom Dialogue script step sets a variable $StartDate.

      Another script step sets a variable $filename to include the start date and the current date:

      Set Variable[$filename;Value:"New USERS "& $StartDate &" - "&Get(CurrentDate)&".xls"

      Data Viewer confirms that $filename creates the correct filename.

      The file path in the Export Records step looks like this, file:../../MARKETING MONTHLY NEW USERS/$filename

      When the script runs, an error message tells me "2015.xls" cannot be used as a filename.

      Does this have something to do with the /'s in the $filename variable?

      Any help would be appreciated.

      ---

      FMPA 13

      Mac OS X 10.10