Toad World® Forums

date manipulation in Toad automation tool

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?