Adding date to output file name

[Nikhil86]

Hi There, 

I am a beginner to Alteryx, I have a work-flow which is producing 4 different outputs, all in .xlsx format. 

I am trying to add a date to my outfile : 

For instance: My current outfile is abc.xlsx how can I produce abc 02112020.xlsx ? An output file should include today's date each time work-flow is run. 

Any advise or help is much appreciated. 

[JosephSerpis]

This post might help you. The only change you need to do in the format is replace %Y-%m-%d with %d%m%Y to get the desired date format. 

[atcodedog05]

Hi @Nikhil86 

Here is a workflow for the task. Always names latest date.

Output:

Workflow:

Output tool config:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Nikhil86]

This is actually putting date within the Sheet . I was looking to have the data on my output file name , Maybe I am doing something wrong? 

[atcodedog05]

Hi @Nikhil86 

Is this my workflow?

Output option should be entire file path

[Nikhil86]

This is how I have configured ! But I am not getting todays date appended to my output file name ie Fixed Income_Upload.xlsx

[atcodedog05]

Hi @Nikhil86 

Can you run this workflow and tell me is it working?

I will definitely help you to fix it.

[JosephSerpis · Accepted solution]

Hi @Nikhil86 I amended the workflow and from your screenshot you are missing the file/folder location or the output. You need the entire location of the file that is going to be outputted for this method to work. Therefore all of that syntax you masked in red in the screenshot needs to be incorporated with the formula tool with the filename.

[Nikhil86]

JosephSerpis,

Thanks a lot mate. It worked :)) 

[atcodedog05]

Hi @Nikhil86 

Glad to hear it got solved 🙂

You are allowed to mark multiple posts as solution. Since i solved a part of your task (date aprt) and Joseph solved a part of  your task(path part). Can i request you to mark one of my posts as solution.

Happy to help 🙂

Cheers and Happy Analyzing 😀