Results 1 to 2 of 2

Thread: Week position

  1. #1
    Join Date
    Jun 2003
    Location
    Montreal
    Posts
    38

    Question Unanswered: Week position

    Hi,

    Is there an easy way to get the position (or number) of the week from a date? By position, I mean week number 1 if we are january 1st. For example:

    Date | Week postion
    =====================
    2001-01-05 | 1
    1996-12-28 | 52
    1987-06-15 | 26

    Thanks a lot,

    Skip.

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Select Datepart(wk,getdate())
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

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