https://community.qlik.com/t5/Talend-Studio/Appending-date-to-tFileoutputExcel-every-time-job-runs/m-p/2332346#M101235 <P>Hello everyone<BR />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 <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span><BR />Any advice is greatly appreciated.</P> Thu, 21 Jan 2016 19:41:40 GMT Anonymous 2016-01-21T19:41:40Z https://community.qlik.com/t5/Talend-Studio/Appending-date-to-tFileoutputExcel-every-time-job-runs/m-p/2332346#M101235 <P>Hello everyone<BR />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 <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span><BR />Any advice is greatly appreciated.</P> Thu, 21 Jan 2016 19:41:40 GMT https://community.qlik.com/t5/Talend-Studio/Appending-date-to-tFileoutputExcel-every-time-job-runs/m-p/2332346#M101235 Anonymous 2016-01-21T19:41:40Z https://community.qlik.com/t5/Talend-Studio/Appending-date-to-tFileoutputExcel-every-time-job-runs/m-p/2332347#M101236 The output path of the file must be assembled like this: <BR /> <BR /> <PRE>"/var/data/" + jobName + "_" + TalendDate.getDate("MM.dd.yyyy") + ".xlsx"</PRE> Sun, 24 Jan 2016 20:47:34 GMT https://community.qlik.com/t5/Talend-Studio/Appending-date-to-tFileoutputExcel-every-time-job-runs/m-p/2332347#M101236 Anonymous 2016-01-24T20:47:34Z