Solved

SSRS Date formatting

Posted on 2011-09-15
6
703 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 300 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
Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

 
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 200 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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server 2012 rs - Sum each category by month 4 41
date diff with Fiscal Calendar 4 57
Upgrading my SSIS package in VS 2012 6 61
SQL - format decimal in a string 5 40
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

830 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