Hi,
I would like to add the current date to the output folder name of a Jet Reports single report that is run by the Jet Scheduler.
I have tried adding the syntax %YEAR% %MONTH% %DAY% in the folder name or the file name and the job returns an error and does not run.
For reference, I have read this post https://support.jetglobal.com/hc/en-us/community/posts/115008495668-Use-Date-in-folder-or-file-name-in-Scheduler .
As a workaround, I also tried to use the Windows Task Scheduler to add a second task, after the Jet Report finished running, to rename the output file. If I edit the Windows task , for some reason the job disappears all together from the Jet Scheduler jobs list, which is an undesired side effect, so this is not a working alternative solution.
I am aware that this can be done differently by using a batch report, but I don't want to create a batch report for each single simple report that is running.
Please let me know if I am using the syntax wrong, are there are any quote "" characters that need to be added for this to work. Example output folder name or filename I used that does not work:
...\foldername-%YEAR%-%MONTH%_%DAY%
filename-%YEAR%-%MONTH%_%DAY%.xlsx