Created Date Name based off of Parameter

[fcoley]

I have a parameter, @MaxDate.. I need to create a field off of that date to return:

Prior month's enddata, for example. If I pass in 10/10/2011 as the @MaxDate, I want to return September 30 ,2010 or 9/30/2010?

How can I accomplish this?

Thanks a bunch!!

 

[MarkSweetland]

Untested, but could you use an expression like:

DATEADD(DAY, -(DAY(Parameters!MaxDate.Value)), Parameters!MaxDate.Value)

and format the output?


Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach