Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Birmingham, UK
    Posts
    121

    Unanswered: Obtaining a date based on a week no

    Hi Folks,
    I have a query which returns the week no for all the weeks in this year up to todays ie 1 - 49. Is there any way of finding out, for instance, what Saturdays date was against the week. Not sure I've explained that too well but I would expect the query results to look something like this:

    Week No Sat Date
    1 10/1/2003
    2 17/1/2003
    3 24/1/2003
    4 31/1/2003
    etc..........

    thanks in advance.

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    the problem with week numbers is defining week 1

    post the definition of week 1 you want to use and the rest is quite easy.

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Sep 2003
    Location
    Birmingham, UK
    Posts
    121
    You're right, been looking at it for too long!!!!!
    Job done, lovely

Posting Permissions

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