I've searched the community for adding a date to a filename, but nothing I've found seems to work after a render. My table is rendered and outputted to a mapped drive. Is there a way to add the date to the filename without modifying the rendering?
I have a workflow that does something similar but can't picture your specific problem without seeing it.
For my use case, I created a full path name using a formula: "\\FullPath\FileName_"+DateTimeToday()+".xlsx". I used that field as the "Group By" in the Basic Table Configuration before the Render Tool.
If that doesn't work, can you please provide a sample of your workflow and more details? We can help.