datepart("ww") headache

Results 1 to 2 of 2

Thread: datepart("ww") headache

  1. #1
    Join Date
    Dec 1969

    Default datepart("ww") headache

    Hello,<BR><BR>some of my intranet stuff uses records based on weeks as the company here work mainly on weeknumbers.<BR><BR>everything ran fine till this year.<BR><BR>the problem is that we euro&#039;s base out start of a week on monday, US folks use sunday which result that datepart("ww",date) results 2 instead of 1.<BR><BR>I just had a look at the regional settings but couldn&#039;t find where I could define the start of week day on this W2K server.<BR><BR>any idea where I could modify this?

  2. #2
    Join Date
    Dec 1969

    Default Read the docs for DATEPART

    They explicitly tell you how to specify the starting day of the week and what defines the first week of the year.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts