Toad World® Forums

TDP 3.6 automation script if condition expression

I am trying to build an if condition to have my automation script send 1 email if the current day is Monday through Friday, and a different email if it is Saturday. What expression could I use to do this? Also, does anyone know if there is a document with valid expression parameters? I feel like I have to guess and just try a bunch of stuff until something works.

I figured out one option: To_char(Current_date(), ‘DDDD’)<>‘Saturday’. Any other suggestions?

It sounds about right.

Igor.