Re: week of year function

} }Hi there, } }I'm searching for a date function which returns me the week of the year. } }Can somebody help me ! } }Thanks ! } }Steffen } Hi.. Steffen, Hope this query works.... select month(date_field) + round(day(date_field)/7,0) from table; Regards, Praveen Mohanan Never Say Die. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com