Rename with specific name and today's date


I want to rename the file from SQL Data table and move to some location with below naming convention.

I am using workbook activity.

location to save file + ABC 2021.05.04 xyz name .xlsx


Try mentioning the path like this

String.Concat(“your location path”, “\”, “ABC”, “”, Datetime.Now.ToString(“yyyy_MM_dd”), ””, “xyz”, “name”, “.xlsx”)

I would suggest not to use space between Filename and that’s why I have mention _ instead of space
And don’t use dot as well along the Filename which may confuse the bot
Use underscore instead of space and dots

Hope this would help you


1 Like

Thank You @Palaniyappan

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.