Hello,

i> Select
i> WEEK_OF_YEAR(DATEFIELD)
i> FROM TABLE

i> but this doesn't work. It returns that WEEK_OF_YEAR is unknown...

try this:

select
T.*,
(select WEEK_NO from WEEK_OF_YEAR(T.DATEFIELD) WEEK
from TABLE T

Not sure whether it will work or not. Worth a try though.
Ciao
--
Nando Dessena
mailto:nandod@...