snippetMinor
How to convert execution time to a specific format?
Viewed 0 times
formathowconverttimespecificexecution
Problem
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?
How can I format the report exectuion time to the format DDMONYY?
Solution
I found this article: Working with Dates in Reporting Services
I can't test right now, but try this:
I can't test right now, but try this:
=Format(Cdate(Parameters!Date.Value),"ddMMMyy")Context
StackExchange Database Administrators Q#23215, answer score: 7
Revisions (0)
No revisions yet.