I am asking if functionality from Toad for SQL Server 5.8 transferred over to 6.5 version and if so, what the new syntax might be.
In version 5.8, I had an Automation Script that created an email and the title of the Email was:
Facility Daily Report for #yyyy-MM-dd#
This would automatically add the current date in that format to the email being sent (subject line would read: Facility Daily Report for 2016-10-06). In version 6.5, this syntax is not recognized; although, I did see it as Date(‘YYYY-MM-DD’) somewhere. I’ve tried all versions of the Date(‘YYYY-MM-DD’) and cannot get this to work. Are we still able to do this in version 6.5? If so, how?
Also, in adding an attachment, I used to use the same syntax (#yyyy-MM-dd#) to have Toad pull file with the latest date. This is no longer recognized in version 6.5. I am assuming if it is still a function in 6.5, it can be done in both the subject line as well as the attachments section.
Any help is GREATLY appreciate!