Converting Week Number to Date

Hi,
I am generating a report that displays trend data on a week by week basis.  I grouped my data set on the completion date by weeks:  Format("ww",Fields!Quantity.Value).  Now that I have the week number for the groups, I would like to display the chart using the Monday(or Friday) as the X axis label.  Is there a way to do this?  I'm using SQL Reporting Services 2005.
Thanks in advance!
keicy01Asked:
Who is Participating?
 
keicy01Connect With a Mentor Author Commented:
I was able to figure it out, see below:
=Format(DateAdd("d",(2 - Weekday(Fields!CompletedOn.Value)),Fields!CompletedOn.Value),"MM/dd")
This code returns the Monday of the completed date field in the MM/dd format.
Thanks.
0
 
chrismcCommented:
Not quite sure I understand.

You're grouping the data by week number but want to label it with day name?

0
 
keicy01Author Commented:
chrismc,
yes, I'm grouping the data by week successfully, I just can't get the label to display correctly.  I will like the label to display the first day of that week no.
thanks.
0
 
chrismcCommented:
Fine by me.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.