Append Input Date to Output File name

[areeba]

Hi ,

Is it possible to take date from input file/source file and append it in the Output file ?

For eg:

Input File name is : 'Orange- Fruits and Vegetables(weekly) - Organic Farm Land 2020-09-30  _08_03 CEST.xlsx'

My output file name should be like this:  'Fruits Overview 2020-09-30'

Regards

Areeba

[areeba]

Hi @atcodedog05 

It is coming NULL

[atcodedog05]

@areeba  can you show me date column.

[areeba]

Hi @atcodedog05 

[atcodedog05]

hmm thats strange. Use this formula in date formatted formula.

Right([Date],7)

and show me date formatted column.

[areeba]

@atcodedog05 

Yeah , it is strange. Now i am getting this

[atcodedog05]

perfect we are close. change the date formatted formula to this

TrimLeft(Right([Date],7),"-")

[areeba]

@atcodedog05 

Bingo !

but I also need to put '0' if month is single digit like here '09-2020'

[atcodedog05 · Accepted solution]

Try this formula in date formatted

IIF(Contains(Right([Date], 7),"-"), "0"+TrimLeft(Right([Date],7),"-"), Right([Date],7))

[areeba]

@atcodedog05 

It Worked...😁

I hope it will take care when month become double digit , then it should appear 12-2020 not 012-2020..just getting sure😋

[atcodedog05]

@areeba Finally we solved it Hi-Fi🖐

Happy to help 🙂

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂