Appending Excel Output with Month, Date and Year Dynamically

[SR]

HI All,

I am new to this tool so need all the help i can get!. I am looking to add a month/date/year to the final excel output file name .  this is a weekly run, so needs to dynamically update the dates. Is that possible?

Example:

File Name : XYZ.xlsx

Rquired FIle Name : XYZ - September 15 2017.xlsx.

Thanks for your help

S

[AmeliaG · Accepted solution]

Hi @SR,

Yes, this is possible! This guide details exactly how to make this happen. 

Let me know if you have any questions and I'd be happy to help :)

Amelia

[NJT]

Just putting a shortcut here to the formula used so that next time I can't remember how to do this I'll find it here right away LOL!

"C:\FilePath\FileName_"+[FileDate] + ".xlsx|||SheetName_"+[FileDate]