Jason Coleman (6/17/2009)
Right... finally started thinking straight...
select
activity_date,
to_char(activity_date,'IW')-to_char(sysdate,'IW') as Date_diff
from
dw.calendar
and then hey presto! :w00t:
Outstanding. Thanks for the feedback on this, Jason.
--Jeff Moden
Change is inevitable... Change for the better is not.