How to add date at the end of output file name

[Nethaji_5]

Hello All,

I would like to add the date at the end of the output file name.

Eg:

Sample Input File(Below): AR Input.xlsx

Output:

Req File Name: AR Output 10-23-2020.xlsx

Kindly please let me know the steps to achieve this and this "Date" should be from the column "Date" in the input file. 

[atcodedog05 · Accepted solution]

Hi 

Here is a workflow for the task.

Output:

Workflow:

Formula:

Output tool config

Hope this helps 🙂

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

[grazitti_sapna]

Hi @Nethaji_5 , try this.

Thanks.

[Qiu · Accepted solution]

@Nethaji_5 
Basically same with @atcodedog05  @grazitti_sapna , but also consider the input file as a variable as well
So it is more dynamic more.

[Nethaji_5]

Hi @Qiu  @grazitti_sapna  @atcodedog05 

Thanks for your reply

Looks like we have 3 different output files at the end but I need a single excel file at the output. 

In my original data set, I'm doing some transformation in the middle and I need to save the file with the date at the end of the file name.

Thanks,

Nethaji

[Qiu]

@Nethaji_5 

The workflow will export single output since the FilePath are the same.

[Nethaji_5]

Hi @Qiu 

Thank you, I'll check 

[atcodedog05]

Hi @Nethaji_5 

I am doing the same as @Qiu but using less tools and keeping it clean.

My formula itself is parsing the date and creating the filename. Instead of using a extra datetime tool

You can give it check 

On a kind note you can accept multiple solutions if it works

Happy to help 🙂

[Nethaji_5]

Hi @atcodedog05 

Thank you so much

[atcodedog05]

Happy to help 🙂 @Nethaji_5 

Cheers and Happy Analyzing 😀