Groups | Blog | Home
all groups > sql server reporting services > december 2005 >

sql server reporting services : Formatting question


Chris Patten
12/16/2005 8:10:02 AM
I want to show a parameter date minus 1 year, how can I do this?

="PERIOD MINUS 1 YEAR: " & Parameters!startdate.Value & " to " &
Oleg Yevteyev
12/16/2005 9:56:57 AM
Try:
="PERIOD MINUS 1 YEAR: " &
System.DateTime.Parse(Parameters!startdate.Value).AddYears(-1).ToShortDateString()
& " to " &
System.DateTime.Parse(Parameters!stopdate.Value).AddYears(-1).ToShortDateString()
or something simular

[quoted text, click to view]

Chris Patten
12/16/2005 10:07:18 AM
That is the shizzle my fizzle!!
(or however that should sound, thanks!)

Chris

[quoted text, click to view]
AddThis Social Bookmark Button