Sergey

You wouldn't happen to know how to do this in SQL Server 2000 as part of a select statement would you?

Thanks

Kirk

>Given a date value, I need to determine what week number that is within the month the date falls in.
>
>Week() function returns the week within the year.

Try

? INT((DAY(ldDate)-1)/7) + 1