calculating week number using a nominated start date 2

[Lochbel]

CRXI
Looking for a simple technique to calculate the week number of a date when the first week of year is to start at a non standard point e.g 28-June-2009.


e.g. 31-August-2009 = Week 10 (when Week 1 commences 28-June-2009)

TIA



Lochbel
Australia

 

[lbass]

Try:

if datepart("ww",{table.date})-datepart("ww", {?startdate}) < 0 then
datepart("ww",{table.date})+ 53 - datepart("ww", {?startdate})+1 else
datepart("ww",{table.date})-datepart("ww", {?startdate})+1

-LB