AnsweredAssumed Answered

Include Date range in variable for export path to Excel

Question asked by sccardais on Mar 5, 2015
Latest reply on Mar 5, 2015 by 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

Outcomes