getting week number from year in report builder RSS

• • Reply
  

  mike72

  Member

  721 Points

  357 Posts

  getting week number from year in report builder

  May 28, 2009 10:42 AM|LINK

  How do I take a datetime field in report builder and write an expression to get the week of the year?
• • Reply
  

  Zong-Qing Li...

  All-Star

  26878 Points

  2165 Posts

  Re: getting week number from year in report builder

  Jun 02, 2009 09:53 AM|LINK

  Hi,

  Please try to use the WEEK function to achieve.

  WEEK(Start_Date)

   

  I look forward to receiving your test results.

  Sincerely,
  Zong-Qing Li
  Microsoft Online Community Support
  Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as
  Answer” if a marked post does not actually answer your question.
  • Marked as answer by Zong-Qing Li - MSFT on Jun 03, 2009 09:54 AM