Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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?
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")
Formatproperty..? – Jon Seigel Aug 27 '12 at 17:54