Week Number

[Lochbel]

Is there a technique i can use to set the week number by specificing a non standard start date.

e.g week commences 01/07/yyyy

TIA

Lochbel
Australia

 

[smcnulty2000]

Depends on what you want to use it for.

DateDiff, DatePart, and WeekdayName all support a first day of week constant. DatePart also supports first week of the year values.

 

[Madawc]

For a week number, use

DatePart ("ww", {date1})

That gives a number, 01 to 53, with adjustments possible to start in some non-standard way.

You could enter the number of the week as a numeric parameter, check it against the DatePart value from the dates.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

If you first insert a group on {@fiscalyear}:

{table.date}+184

You can then use a formula like this for weeknumber:

if month({table.date}) >= 7 then
datepart("ww",{table.date},crSunday)-26 else
datepart("ww",{table.date},crSunday)+26

At least this should get you close to what you're looking for.

-LB