AUTOMATION- Defining folder name in script- changes every month

tricia.j.paclebreyes · November 28, 2011, 2:49pm

Hello- For automating reports in TDA I want to change the script to save the automated output in a different folder when the month changes:

For example- my automated report runs today and it is 11/28/2011 - it will save in REC_REPORTS_2011_11

Next Monday when it runs again it will be 12/05/2011- I WANT it to save in
REC_REPORTS_2011_12

How can I do this in the automation script?

Debbie_Peabody · December 6, 2011, 3:20pm

Try setting a variable to the name of the directory. Then use the variable in the file name. Use the "#" when using the variable. See the attached screenshot.

Debbie