Dynamically add the date to the output(excel spreadsheet) filename

Question

Hello,

I have a workflow, the output of the workflow is written to an excel spreadsheet, the filename should . contain date range along with the name of the file

Date range: current date and going back 28 days from current date

If today's date is: '2020-10-26'

Here is what I need:

expected file name: UNFI-NWXD Report between '2020-09-28' and '2020-10-26'

Appreciate your help

Regards,

Harsha Rappan

Emil_Kos · Answer

Hi @harsha_rappan,

It looks that the solution provided you by @atcodedog05 is saving the file with a new dynamic name.

If you want to rename the file that is an input file you cannot do that.

You need to create a new file with a new naming convention as @atcodedog05 did.

If you want to delete the original file you would need to add a cmd command to your workflow.

harsha_rappan · Answer

Thank you for the quick reply, my requirement is to dynamically rename the file, not the sheet name or the tab name in the excel spreadsheet.

The solution provided by you is dynamically writing the name at the bottom of the excel spreadsheet (sheet name), which is not my requirement

When my file (excel spreadsheet) is saved to my local machine or to any folder, the name of the file should be dynamically written, this is my desired requirement

I hope this helps

Regards,

Harsha Rappan

Emil_Kos · Answer

Hi @harsha_rappan,

ahh, I missed it should be 28 days from today's date 🙂