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 | |
|---|---|---|---|---|
| Toad Automation Scripts | 1 | 1050 | July 19, 2017 | |
| Setting a Dynamic Date Range in Toad Data Point 3.2 | 3 | 1000 | November 17, 2014 | |
| TIC Automation - Day of the week function returning different values | 0 | 562 | April 6, 2022 | |
| Automation - Date expression for current day of week | 1 | 358 | May 10, 2023 | |
| Date Format issue with Toad 10.6.1 | 1 | 1210 | April 4, 2012 |