Excel Query
Hi Jamie,
Thank you for reply. I will try giving a CASE Statement a
try.
Dave Y
-----Original Message-----
"Dave Y" wrote ...
script that I run returns the previous days information
from the DB using a SYSDATE -1 statement.
As it stands now, I manually edit
the SQL script to bring back the information from
Saturday.
I don't have Oracle to check how its proprietary
functions work but
could you perhaps test for Monday using:
to_char(sysdate,'DDD')
in a CASE (or equivalent) statement?
Jamie.
--
.
|