Format dates in SSRS reports

Displaying dates in different formats in your reports is a very common requirement that one faces while working with Sql Server Reporting Services (SSRS).

Let us see how we can display dates in different formats :

=Format(Fields!myDate.Value, “M/d/yy”) - 2/11/08
=Format(Fields!myDate.Value, “MM/dd/yyyy”) - 02/11/2008
=Format(Fields!myDate.Value, “d-MMMM-yy”) - 11-December-08
=Format(Fields!myDate.Value, “d-MMM-yyyy”) - 11-Dec-2008 =Format(Fields!myDate.Value, “M/d/yyyy H:mm”) - 2/11/2008 13:50
=Format(Fields!myDate.Value, “MMM-dd-yyyy”) - Feb-11-2008
at

6 comments:

  1. Smitha PrabithJuly 9, 2008 at 12:03 AM

    Thanks a lot for the different Date formats
    =Format(Today(),"dd-MMM-yy")
    is also one which i was using
    it gives:
    09-Jul-08

    ReplyDelete
  2. PhilkyJuly 23, 2009 at 12:51 PM

    Thank you for this post. one thing I want to do is get the previous year using MMM-yy.

    ReplyDelete
  3. Suprotim AgarwalJuly 26, 2009 at 10:23 PM

    P - You will have to get the previous date in your SQL query and then use the same expression to convert it to MMM-yy. Since you haven't mentioned any other conditions on which month of the previous year, here's a post that may help you out

    Finding the date last year based on the current week

    ReplyDelete
  4. AnonymousDecember 9, 2010 at 5:56 AM

    Hi, I'm doing something like this

    "=Format(Fields!dataRef.Value,"MMMM")+ "/"+Format(Fields!dataRef.Value, "yyyy")"

    Can I translate the month's name to portuguese?

    Thank you.

    ReplyDelete
  5. POLLADHAVANJanuary 20, 2011 at 12:04 PM

    Hi,

    I am having a problem with SSRS
    I have a column with data type in Time format like
    12:24
    06:45

    I need to sum up the values and display as a total.

    Can any one provide me the expression please.

    ReplyDelete
  6. Ezhumalai MJuly 24, 2012 at 9:35 PM

    Thank for your post.lot of helpfulness for me

    ReplyDelete