Appending date to tFileoutputExcel every time job runs
Hello everyone I am writing a job that runs weekly. The output is an excel file. How do I append a date when job is run to the output excel. E.g. if the job runs today (1.20.2015) and Excel name is TEST_JOB, I would like the Excel to be called TEST_JOB_01.20.2015.xlsx. When the job runs a week from now the excel name should be TEST_JOB_01.27.2015.xlsx. I am not very concerned about the formatting of the date as much as how to get it there Any advice is greatly appreciated.