<div>
Hi,<br />
<br />
&nbsp; you can also use the Date Format Options from the Property for the particular Field...<br />
<br />
<br />
choose custom format and type the following<br />
<br />
<br />
dd &quot;th&quot; MMM yyyy
</div>


Hi,

  you can also use the Date Format Options from the Property for the particular Field...


choose custom format and type the following


dd "th" MMM yyyy

<div>
This solution covers all days...<br />
<br />
<a href="http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/e81023a3-baf3-4b3b-bf01-2e734691e1c7/" rel="ugc nofollow">http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/e81023a3-baf3-4b3b-bf01-2e734691e1c7/</a>
</div>


This solution covers all days...

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/e81023a3-baf3-4b3b-bf01-2e734691e1c7/ [http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/e81023a3-baf3-4b3b-bf01-2e734691e1c7/]

<div>
Right Click on Field and open property window.<br />
<br />
Select Number Tab and select format as date and also choose options as you like (DD/MM/YY, MM-DD-YYYY etc. etc.)
</div>


Right Click on Field and open property window.

Select Number Tab and select format as date and also choose options as you like (DD/MM/YY, MM-DD-YYYY etc. etc.)

<div>
HI SThaya your solution below is giving the date as I wanted like 15th sep 2011. But what if I want th to be as a degree on top of 15. because normally th will be like a degree on top of the day.<br />
<br />
=DatePart(&quot;d&quot;,Today.Date)&amp;<wbr />&quot;th &quot;&amp;&nbsp;Left(MonthName(Month(Today<wbr />.Date)),3)<wbr /> &amp;&quot;&nbsp;&quot;&amp;<br />
Year(Today.Date)
</div>


HI SThaya your solution below is giving the date as I wanted like 15th sep 2011. But what if I want th to be as a degree on top of 15. because normally th will be like a degree on top of the day.

=DatePart("d",Today.Date)&"th "& Left(MonthName(Month(Today.Date)),3) &" "&
Year(Today.Date)

<div>
<div class="content wysiwyg-content">
HI, I am using the blow expression in my SSRS report to get<br />
the below date.<br />
<br />
=Format(Today.Date,&quot;dd MMM yyyy&quot;)<br />
<br />
I am getting the date rightly as 15 Sep 2011. BUt I want to<br />
get it as 15th Sep 2011. Is there any way in SSRS to do that ?<br />
<br />
Many Thanks
</div>
</div>


HI, I am using the blow expression in my SSRS report to get
the below date.

=Format(Today.Date,"dd MMM yyyy")

I am getting the date rightly as 15 Sep 2011. BUt I want to
get it as 15th Sep 2011. Is there any way in SSRS to do that ?

Many Thanks

SSRS Date formatting

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.