Results 1 to 3 of 3

Thread: Date of First Day in Week

  1. #1
    Join Date
    Apr 2005
    Location
    UK
    Posts
    6

    Date of First Day in Week

    I need to write a user defined function that will return the date of the first day of a week when provided with the week number. I had an idea of using a while loop with that will keep adding 1 day from January 1st until the week number (found via the DATEPART function) is equal to the supplied week number. Not sure if this is the best way though - any ideas?

    Donald.

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254

  3. #3
    Join Date
    Apr 2005
    Location
    UK
    Posts
    6
    Excellent, exactly what I was looking for! Many thanks!

Posting Permissions

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