Hello, I need some help...
I have a sql query (Oraacle) wht hase a date staement in the WHERE clause.
I need for it to pull the previous wok day as a criteria in the WHERE.

ie. SELECT *
FROM xxxxxx
WHERE my_date is between
(yestdays workdat and time 00:00:00am) and (yesterdays valid work date 11:59:00)
can any one help, please...
thanks
Kipp