Week Numbers and week start dates

• balars_2000

  Right there with Babe

  Points: 717

  More actions

  June 9, 2009 at 12:11 am

  #222255

  Hi Folks,

  Can you help me out with this?

  I have a report that displays the week # and start of the week date and sums up revenue collected for the period.

  For example, if I choose current year, Week # would start as 1 and start of the week should be 5/01 (first Monday of the year) and so on till current week which is 24 and week date is 08/06.

  Thanks.

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  Follow

  June 9, 2009 at 12:53 am

  #1006471

  OK. How can we help?

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]