How to Rename excel file with date

[ShivuDundi (Shivu Kumar)]

Hello Community,

I have scenario where in i need to copy template file and move to output folder,
though i am able to copy and rename filename followed by current month and year.

strTempName=strTempName.Replace(“{0}”,Now.ToString(“MMyyyy”))

output is :- VarianceAnalysis_012021.xlsx

but expected output is :- VarianceAnalysis_0121.xlsx

Need Suggestions. @NIVED_NAMBIAR

[NIVED_NAMBIAR (NIVED N)]

Hi put the filename as below

“VarianceAnalysis_”+Now.ToString(“MMyy”)+“.xlsx”

[ShivuDundi (Shivu Kumar)]

Thanks For the reply i tried ,but i am getting Same output no change

[Pradeep_Shiv]

@ShivuDundi

VarianceAnalysis_012021.xlsx

HI @ShivuDundi,

also you can try this, “VarianceAnalysis_012021.xlsx”.Replace(Now.ToString(“yyyy”),Now.ToString(“yy”))

[NIVED_NAMBIAR (NIVED N)]

Just edited my answer

Please check

[ShivuDundi (Shivu Kumar)]

I got it …Thank You