I used to work with Toad for SQL Server 5.8 and I have been asked to migrate my automation files to TDP 3.7 (version 184.108.40.2063). In my Toad for SQL Server 5.8, I had automated the sending of an email that picked the most current Excel file and added the current date on the email’s subject file. I accomplished this by adding the following syntax to the “attachment’s” name and in the subject line:
Email subject: Group Census for #yyyy-MM-dd#
With this setup, my query would run, adding the current date to the file name (Daily_Report_for_2015-09-23.xlsx). This file is then selected by the email setup step because of the syntax and the email is sent out with the subject line: Group Census for_2015-09-23.
Now in TDP 3.7, I cannot get this to run properly. I receive an error "Toad has detected some symbols within the expression indicating you might be using bind variables. Please define the following variable(s): yyyy-MM-dd.
How can I work around this to make this work again?