Solved

SSRS Date formatting

Posted on 2011-09-15
6
713 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

734 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