Adding date to output file name

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.

Output

Accepted answers

JosephSerpis

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.

Fileaname_02112020.yxmd

All comments

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 😀👍

date file.yxmd

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?

jmo95

Hi, is there a way to exclude the added column for date from the output?

I have successfully added date and time stamp to workflow outputs but its also adding an additional column containing the data to my output that i dont want. if i remove it via selector prior to the output then its not present for the output to pick up and name my file.

thanks.

CarterJ

in your output to excel configuration window uncheck the "keep field in output" box... this will remove the field that contains the file path with date field from your output

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703