Fantastic, this solved our problem and we can now schedule reports as desired. Thank you!
However, seemingly from nowhere we've spawned a different issue that was working flawlessly last week. I'm nearly 100% sure nothing else changed and I'm a little baffled. Thanks in advance for helping us tie up this loose end before we move Logicity to production.
Issue: VBScript in Excel File Name and Log File Name is now creating deeper directories in which files are saved with incorrect names
Details: Action File Name: PDMeds_%{DateAdd("d",-1,Date)}%.xls (Use run date of today as example)
- Last week file would be saved as: ...\PDMeds\PDMeds_6-19-2017.xls
- Now files are saved as: ...\PDMeds\PDMeds_6\19\2017.xls where slashes are interpreted as directories and the file name is just '2017.xls'
Any idea what caused this change? I made zero changes to the Action/Log File Name fields, now they are being outputted with a different format.
As a test, I just changed Action File Name to: PDMeds_%{Date}%.xls and it also buried the .xls file in ...\PDMeds\6\20\2017.xls, where \PDMeds\6\20\ is the directory and 2017.xls is the file name.
Reading online it seems that slashes are how VBScript should be outputting. My question is why was it outputting with dashes instead slashes previously, and how can I get it back to outputting this way?
Thanks,
Jackson