Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 435
  • Last Modified:

how do I calculte the week of the year calculation in visual studio 2010

I need to calculate the week of the year for an SSRS report that I'm writing using Visual Studio 2010.  There are Day, Month and Year functions, but no Week function (like is available in Excel).

So, how do I calculte the week of the year calculation in visual studio 2010?
0
makingitbig
Asked:
makingitbig
  • 3
  • 2
1 Solution
 
Jaime OlivaresCommented:
You should look at .net method GetWeekOfYear ( http://msdn.microsoft.com/en-us/library/system.globalization.calendar.getweekofyear(v=vs.110).aspx )
There are many considerations for invoking it, depending on your culture specifics. Here is an example of usage:

var dt = DateTime.Now;
CultureInfo.InvariantCulture.Calendar.GetWeekOfYear (dt, CalendarWeekRule.FirstDay, DayOfWeek.Monday);

Open in new window

0
 
makingitbigCIOAuthor Commented:
I'm not familiar with variable declaration within calculated fields in an SSRS dataset; your example looks more like VB code, correct?

To compensate, I tried the suggestion in this form:

=CultureInfo.InvariantCulture.Calendar.GetWeekOfYear(Fields!ODR_DATE.Value,CalendarWeekRule.FirstDay,DayofWeek.Sunday);

When I try to preview my report an error message appears essentially saying

'CultureInfo' is not declared.  It may be inaccessible due to its protection level.

This occurred even though Intellisense recognized the CultureInfo.InvariantCulture.Calendar.GetWeekofYear method.

Perhaps you could help me understand how to get the week of year from within an SSRS project.
0
 
Jaime OlivaresCommented:
Hi, it may need to be fully qualifies. Please try to add System.Globalization. before CultureInfo
0
 
makingitbigCIOAuthor Commented:
adding System.Globalization. before CultureInfo and also before CalendarWeekRule did the trick.

Thanks!
0
 
makingitbigCIOAuthor Commented:
by the way, if you have links/recommendations on where I can learn more about all of the methods available (through Visual Studio?), I'd appreciate it.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now