asked on 10/10/2011

SSRS Displaying Date Incorrectly

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?

Thanks.

SSRS

Last Comment

vbasqlprogrammer

10/10/2011

SThaya

10/10/2011

Hi,

use the bleow expression

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

itcouple

10/10/2011

Hi

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

Regards
Emil

ASKER CERTIFIED SOLUTION

SThaya

10/10/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

vbasqlprogrammer

10/10/2011

ASKER

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.

Thanks.