Re: Touble With Dates



"Joseph Lamb" schreef:

s.shipdate
<snip>
TO_CHAR(SHIPDATE, 'MMDDYY') = TO_CHAR(SYSDATE-21, 'MMDDYY') and


Maybe you need to replace "SHIPDATE" by "s.shipdate"?

--
Affijn, Ruud

"Gewoon is een tijger."


.