<div>
Try -<br />
<br />
Format(Parameters!parEndin<wbr />gDate.Valu<wbr />e,&quot;MMMM DD, YYYY&quot;)
</div>


Try -

Format(Parameters!parEndingDate.Value,"MMMM DD, YYYY")

<div>
If do that the out put comes &nbsp;For the Period MMMM DD ,YYYY<br />
Any other suggestions?
</div>


If do that the out put comes  For the Period MMMM DD ,YYYY
Any other suggestions?

<div>
Sorry, my mistake.. DD, YYYY should actually be in lower case -<br />
<br />
Format(Parameters!parEndin<wbr />gDate.Valu<wbr />e,&quot;MMMM dd, yyyy&quot;)<br />
<br />
The complete list of format codes are available in this link below -<br />
<br />
<a href="http://thavash.spaces.live.com/blog/cns!CF6232111374DFD2!197.entry" rel="ugc nofollow">http://thavash.spaces.live.com/blog/cns!CF6232111374DFD2!197.entry</a>
</div>


Sorry, my mistake.. DD, YYYY should actually be in lower case -

Format(Parameters!parEndingDate.Value,"MMMM dd, yyyy")

The complete list of format codes are available in this link below -

http://thavash.spaces.live.com/blog/cns!CF6232111374DFD2!197.entry [http://thavash.spaces.live.com/blog/cns!CF6232111374DFD2!197.entry]

<div>
Its coming as MMMM dd,yyyy now.Any other ideas?
</div>


Its coming as MMMM dd,yyyy now.Any other ideas?

<div>
Can you retry after removing the comma like -<br />
<br />
Format(Parameters!parEndin<wbr />gDate.Valu<wbr />e,&quot;MMMM dd yyyy&quot;)
</div>


Can you retry after removing the comma like -

Format(Parameters!parEndingDate.Value,"MMMM dd yyyy")

<div>
Nope that doesnt work either....any more suggestions?
</div>


Nope that doesnt work either....any more suggestions?

<div>
How about -<br />
<br />
Format(Parameters!parEndin<wbr />gDate.Valu<wbr />e,&quot;MMMM dd&quot;) &amp;&nbsp;&quot;,&quot; &amp;&nbsp;Format(Parameters!parEndin<wbr />gDate.Valu<wbr />e,&quot;yyyy&quot;)
</div>


How about -

Format(Parameters!parEndingDate.Value,"MMMM dd") & "," & Format(Parameters!parEndingDate.Value,"yyyy")

<div>
I should have caught that, didn't realise parEndingDate.Value was not a datetype!
</div>


I should have caught that, didn't realise parEndingDate.Value was not a datetype!

<div>
<div class="content wysiwyg-content">
Hi,<br />
I am using a parameter &nbsp;like this in my report <br />
&quot;For The Period to&quot; &amp;&nbsp;Format(Parameters!parEndin<wbr />gDate.Valu<wbr />e,&quot;Short Date&quot;) and i get <br />
1/31/2008.How do i format it to get something like January 31,2008.<br />
Thanks,
</div>
</div>


Hi,
I am using a parameter  like this in my report 
"For The Period to" & Format(Parameters!parEndingDate.Value,"Short Date") and i get 
1/31/2008.How do i format it to get something like January 31,2008.
Thanks,

How to Fromat Date in Sql Server RDLC

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.