I'm trying to format the label of a parameter which is populated by a dropdown in SQL2008 RS. Essentially, i want to put a title in the report which puts the date in the format dd MMM yyyy.
I have tried the following options with no luck:
=Format(Parameters!MyDate.Label, "dd MMM yyyy")
=Format(CDate(Parameters!MyDate.Label), "dd MMM yyyy")
Can this be achieved in this way? I "could" reformat the data in the dataset, but i'd rather explore this avenue first.
TIAevery day is a school day
View Complete Post