I am working on a report that allows people to print off data for physical signatures. Part of the requirement is to format the exectuion date in the format DDMONYY (27Aug12). I can not find a way to set the format of the date in the report.
How can I format the report exectuion time to the format DDMONYY?
Best Answer
I found this article: Working with Dates in Reporting Services
I can't test right now, but try this:
=Format(Cdate(Parameters!Date.Value),"ddMMMyy")