Manipulate weeknumber 1

[Erwin]

I use MSOWC to be able to view data in pivottables in IE. One of the features
is that a field of type date is available in date by month and date by week.

My problem is in "date by week".

MSOWC considers the week that contains January 1 as weeknumber 1. In The
Netherlands (and other countries) this is not so. Here the first week of the
year is the week thas has most days in this new year. So 2004 has a week 53
and the week that starts on Sunday Januar 2 is week 1.

MSOWC considers January 1 in week 1.

Can anybody tell me how I can manipulate these setting?

Regards! Lots of them!

 

[Alvin Bruney [MVP]]

One approach to this is to set the appropriate culture information on the
client-system. The OWC uses culture information to make these
determinations. If this does not work, you will have to provide custom code
to take over the date functionality on the pivot table.

--
Regards,
Alvin Bruney

Shameless Author plug
The Microsoft Office Web Components Black Book with .NET
http://tinyurl.com/27cok

 

[Erwin]

I'm very sorry, but your suggestion does not work. It seems like it is hard
coded in the dll that is used that January 1 is allways in week# 1.

The country/date and whatever setting on the client does not seem to
influence this.

Off course it is possible to add a calculated field to the fieldlist, but
the function which extract a date field into a date-by-week and date-by-month
cannot be influenced.

Or am I seriously missing anything??

/Erwin

 

[Alvin Bruney [MVP]]

no i think that is the default behavior. sorry, i have no further ideas.

 

[Alvin Bruney [MVP]]

no i think that is the default behavior. sorry, i have no further ideas.