Include Date range in variable for export path to Excel
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.
Mac OS X 10.10