>There is a slight bug in the expression
>
>WEEK(dDate, 1, 2) - WEEK(DATE(YEAR(dDate), MONTH(dDate),1)) +1
>
>because the first WEEK() function uses Monday as the first day of the week, and the second one uses Sunday. For example, if you set dDate to Feb. 1, 2004, the above returns 0.
>
>If you change the expression to
>
>WEEK(dDate) - WEEK(DATE(YEAR(dDate), MONTH(dDate),1)) +1
>
>it is consistent.
Thanks, we'll take that in consideration.