Need help with getting Weekday from data parameter in SSRS report headder
Posted on 2010-11-08
I have a report that I am writing in SSRS. In the report header, Iv'e got a textbox that I need to display "Wednesday 11/10/2010 yadda yadda yadda". How do I get the "Wednesday"?
Currently I've got the textbox value set to:
= "For " & Parameters!ForDate.DayOfWeek & " " & Parameters!ForDate.Value & " yadda yadda yadda "
but that just yields "For 0 11/8/2010 yadda yadda yadda"
How do I easily convert the numerical day value to text without a lot of syntax?