B
Buscado
We have built a BI-reporting applicaton not unlike MS BI Portal using all Ms
components. (IE6.0 + OWC10 + SQL2000).
Using the OWC pivot tables, somehow somewhere, somebody generates two extra
date structures in the field set giving “Date by week†and “Date by Monthâ€
which is just great. However the Sunday is assumed as first day of the week
and the first week of the year starts on January 1st. I assume the week
numbers are calculated using the statement format(Mydate, “wwâ€) or maybe even
worse hard coded
format(Mydate, “wwâ€, 1, 1).
Using a calculated field with the statements format(Mydate, “wwâ€, 0, 0) or
format(Mydate, “wwâ€, 2, 2) return the values I want to use. (I am aware of
the underlaying VB definitions).
Insignificant as this might seem initially for my application this is a
critical issue. Can you imagine the whole organization reporting Turnover
information in a week that, according to our calendar has yet to begun!?
My burning question : How do I get the “Date by week†structure to return
week numbers using using the NLS API settings!
components. (IE6.0 + OWC10 + SQL2000).
Using the OWC pivot tables, somehow somewhere, somebody generates two extra
date structures in the field set giving “Date by week†and “Date by Monthâ€
which is just great. However the Sunday is assumed as first day of the week
and the first week of the year starts on January 1st. I assume the week
numbers are calculated using the statement format(Mydate, “wwâ€) or maybe even
worse hard coded
format(Mydate, “wwâ€, 1, 1).
Using a calculated field with the statements format(Mydate, “wwâ€, 0, 0) or
format(Mydate, “wwâ€, 2, 2) return the values I want to use. (I am aware of
the underlaying VB definitions).
Insignificant as this might seem initially for my application this is a
critical issue. Can you imagine the whole organization reporting Turnover
information in a week that, according to our calendar has yet to begun!?
My burning question : How do I get the “Date by week†structure to return
week numbers using using the NLS API settings!