Solved

SSRS Date formatting

Posted on 2011-09-15
6
719 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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

627 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