HiveBrain v1.2.0
Get Started
← Back to all entries
snippetMinor

How to convert execution time to a specific format?

Submitted by: @import:stackexchange-dba··
0
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?

Solution

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")

Context

StackExchange Database Administrators Q#23215, answer score: 7

Revisions (0)

No revisions yet.