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
Solved! Go to Solution.
@areeba can you show me date column.
hmm thats strange. Use this formula in date formatted formula.
Right([Date],7)
and show me date formatted column.
perfect we are close. change the date formatted formula to this
TrimLeft(Right([Date],7),"-")
Try this formula in date formatted
IIF(Contains(Right([Date], 7),"-"), "0"+TrimLeft(Right([Date],7),"-"), Right([Date],7))
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😋
@areeba Finally we solved it Hi-Fi🖐
Happy to help 🙂
Cheers and Happy Analyzing 😀
Feel free to reach out if you face any issues 🙂