Reporting Services Formatting Date

Question

I create a report in reporting services. I would like the title of the report to read:

Audit Journal - from June 1, 2011 to June 6, 2011

I am currently reading:

Audit Journal - 06/01/2011 to 06/06/2011

I use expression

="Audit Log - " + Parameters!DateStart.Value + " To " + Parameters!DateEnd.Value

I am sure it is quite simple. I'm just pretty new to using reporting services. I am creating a report in visual studio 2005, if that matters.

thank

+3

Curtis Jun 08 '11 at 20:52

1 answer

Devin burke · Accepted Answer · 2011-06-08T20:57:52+0000

Use the function Format()as follows:

="Audit Log: " + Format(Parameters!DateStart.Value,"MMMM dd, yyyy") + " To " + =Format(Parameters!DateEnd.Value,"MMMM dd, yyyy")