I’m trying to use the Automation Designer tool to create a dynamic filename that has the query date range (sysdate-7 and sysdate) in the file name. What I want to see is something like ‘samplefilename_2013-10-23_to_2013-10-30.xls’ , but I’m running into some issues with the first date returning a literal rather than the actual date. In the action file name field I’m putting the following:
And this is what is being returned when the file is created:
**Is there anywhere to get sysdate-7 to return in the filename as a true date? **
Using Toad for Oracle v188.8.131.52
THANKS IN ADVANCE!!!