Have each days output (in excel) make its own separate excel file w/ that days date on it?

[Henry_Gunn]

Hello,

I believe I saw something about doing this somewhere, but I have no idea what to do.

I run the same sales data workflow everyday and it would be perfect if when I run it each morning, it auto creates an excel file with that days date in the file name. So I would have a running batch of sales data files, which I can easily go back into to review by date in the file name.

Today's for example would be Reporting Sales 808/24/22

Not sure if this is a huge lift, but any advice would be super appreciated.

Henry

[ChrisTX]

Look at this Knowledge Base article

Community > Designer > Browse Knowledge > Saving an Excel File with Today's Date

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Saving-an-Excel-File-with-Today-s-Date/tac-p...

and these posts:

How to: Dynamically rename output files
https://community.alteryx.com/t5/Alteryx-Knowledge-Base/How-to-Guide-to-dynamically-renaming-output-...

Create Multiple multiple worksheets from Multiple Inputs date time stamp appended to file

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Create-Multiple-multiple-worksheets-fr...

Datestamp to Ouput File name

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Datestamp-to-Ouput-File-name/td-p/596

[IraWatt]

Hey @Henry_Gunn,

Creating files with todays date on is quite straight forward. Using the date time functions you can create the dynamic date:

With the date you can then make a file path to create your file using this setting in the output tool:

If your interested in learning more about the datetime functions there is a great cheat sheet Blog here: https://community.alteryx.com/t5/Engine-Works/DateTime-Functions-Cheat-Sheet/ba-p/844353

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com