I am trying to set up a variable in the Toad automation tool to get the last Friday but I have not been able to figure out the DatePart function in setting a variable value. Also FormatDateTime only seems to have 4 formats available (no custom formats). My workaround is to call a SQL function and output the result to the automation variable. Is there a Toad function in the script automation tool that can do this?
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| help with blind variables in automation - dates | 7 | 1355 | February 24, 2011 | |
| DateAdd - Set Variable - System Activities | 4 | 2786 | April 16, 2010 | |
| Export dataset|Insert statement | 10 | 1214 | February 16, 2016 | |
| Calculated fields | 3 | 1539 | July 12, 2011 | |
| Format for date query | 14 | 16349 | October 18, 2017 |