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 | 1347 | February 24, 2011 | |
| DateAdd - Set Variable - System Activities | 4 | 2778 | April 16, 2010 | |
| Calculated fields | 3 | 1532 | July 12, 2011 | |
| date function getting different results on different desktop TDA's | 4 | 775 | October 28, 2011 | |
| Different results with and without to_date function | 6 | 2147 | January 3, 2011 |