Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSRS Date formatting

Posted on 2011-09-15
6
Medium Priority
?
728 Views
Last Modified: 2012-06-27
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
0
Comment
Question by:gvamsimba
6 Comments
 
LVL 11

Accepted Solution

by:
SThaya earned 1200 total points
ID: 36543418
Try this

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

Expert Comment

by:SThaya
ID: 36543459
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
0
 
LVL 9

Expert Comment

by:edlunad
ID: 36543559
0
Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 36547424
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.)
0
 

Author Comment

by:gvamsimba
ID: 36547713
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)
0
 
LVL 27

Assisted Solution

by:planocz
planocz earned 800 total points
ID: 36557246
Go to your PC and select start, all programs, accessories, and then select the Character Map
icon.
In there pick the font you want. when the window shows that pick the dress sign and copy and paste to your code.
example:
=DatePart("d",Today.Date)&"° "& Left(MonthName(Month(Today.Date)),3) &" "&
Year(Today.Date)
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question