Output to excel multiple files to same excel file. save with current date

Hello,

I have a work flow that will output data to two tabs in the same excel sheet. This will be a workflow that will be ran daily so i would like to have the file name be updated based on the current date. So if the file name is "Cash Balances" i would like the workflow to be ran and save down a new file called "Cash Balances 06-10-2019".

Attached is my workflow.

Thanks in advance!

OD v2.yxmd

Developer

Accepted answers

unknown

Use a formula tool right before output. The formula tool will be, for this new field:

[ENTER NAME OF FILE]+' '+ToDate(DateTimeNow())

Once you have this new field, you need to replace file name with a field in the bottom options of the output tool. Now you have a dynamic output.

All comments

unknown

Use a formula tool right before output. The formula tool will be, for this new field:

[ENTER NAME OF FILE]+' '+ToDate(DateTimeNow())

Once you have this new field, you need to replace file name with a field in the bottom options of the output tool. Now you have a dynamic output.

jdejesus

Thank you. Took some trial and error and i was able to get it to work.

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335