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.
vbasqlprogrammerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SThayaTechnical MAnagerCommented:
Hi,

 use the bleow expression

=Day(Fields!sdateplan.Value)&"-"&Left(MonthName(Month(Fields!sdateplan.Value)),3) &"-"&Right(Year(Fields!sdateplan.Value),2)
0
itcoupleCommented:
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
0
SThayaTechnical MAnagerCommented:
Hi,

 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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vbasqlprogrammerAuthor Commented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.