saving a file with the current date

[cstafford]

I create a .csv file at the end of a workflow with a static filename. However, since this workflow will be run daily, I want to add the current date to the end of the static filename. How can I add this feature to the workflow?

[jasperlch · Accepted solution]

Hi @cstafford

This can be done by adding a "Today" field using Formula tool to your dataset before the Output tool and check the box of "Take File/Table Name From Field" box in the Output tool:

[cstafford]

thank you, worked great.

[sk1909]

Is there a way to format the date in this without the dashes? I need the date to be YYYYMMDD.

[cstafford]

I would try the DateTimeTrim formula and concatenate as needed

DateTimeTrim(DateTimeToday(),"month"&&"day")

[NJT]

Now how do you do it with Excel files... and format the date @sk1909 was asking about. I'm working on a solution I can't seem to find it solved in the community in the same thread. I think I'll start a new thread that is called using current date in output file names for Excel and other formats and combine it all in one thread. I would think this would be out there already since I can't imagine people not needing this. 

[cstafford]

to my knowledge and experience, it only works for .csv files.

[Soraju]

Did you find a solution to appending date on an excel file output?