Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SSRS Date formatting

Posted on 2011-09-15
6
Medium Priority
?
722 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 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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

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…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

704 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