Toad World® Forums

AUTOMATION- Defining folder name in script- changes every month

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

How can I do this in the automation script?

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.