> select "ItemID", f_weekofyear(cast("ProduceDate" as date)), sum
> ("Qty") as "Qty"
> from "produce" m
> where "ProduceDate" >= '9/1/2003'
> group by f_weekofyear(cast("ProduceDate" as date))
>
>
> Invalid token.
> invalid request BLR at offset 96.
> function F_WEEKOFYEAR is not defined.
> module name or entrypoint could not be found.
>

Still sounds like you need the freeUDFLib.dll file placed in your UDF
directory and the functions need to be declared in the DB

Also, this statement won't work, leave ItemID out of it or group by it as
well as week

Alan