I have an automated query which runs each Monday and exports an excel file to a folder on our work server (I have tried on my local drive also). I would like to append the excel file with the run date. I was able to do this in Toad Data Point, but cannot figure out a way to do it from Toad for Oracle.
I tried the “Filename_%sysdate%” in the output file name, but an error comes up that says “cannot create file “Filename_1\31\2019.xlsx”. The system cannot find the path specified.”
Any help would be appreciated.