SSRS Displaying Date Incorrectly

Posted on 2011-10-10
Last Modified: 2012-05-12
Could some on please tell me why a REport I have created is displaying the date incorrectly.  At the moment it seems to only be for certain months.  

For the date format field I have put :  =Format(Fields!sdateplan.Value, "dd-MMM-yy").  But what displays in the report for 01-Feb-2012 is "01-eb-12" And for 01-Mar-2011 is "01-3ar-11"

Could someone please explain what is happening here?

Question by:vbasqlprogrammer
    LVL 11

    Expert Comment


     use the bleow expression

    =Day(Fields!sdateplan.Value)&"-"&Left(MonthName(Month(Fields!sdateplan.Value)),3) &"-"&Right(Year(Fields!sdateplan.Value),2)
    LVL 10

    Expert Comment


    Try =Format(Today(), "dd-MMM-yy")

    If that works than your field is not in proper format. You might have to cast to date.

    Check your sql to ensure it is date. If not you can cast in sql. Below is link to sql queries example and the first one contains some example with date.

    SQL Queries Examples

    LVL 11

    Accepted Solution


     when i place your format code in the custom properties like "dd-MMM-yy".. it working perfectll
    . can you send me some data in the Fields!sdateplan.Value  field

    Author Closing Comment

    Hi SThaya,

    I put ="dd-MMM-yy" in the format field and it worked fine.  So somewhere along the line it doesn't like the format command for whatever reason.  The field is definately typed as a datetime field on the server, so no problems there, and I even get the problem after casting it as well.  So a wee bit strange.  But however, with this solution it works.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Written by Valentino Vranken. Introduction: In a previous article ( I announced that I would writ…
    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…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now