formating dates -- sql server reporting services

DONNA
12/7/2005 2:54:02 PM

I have a date being input from a stored procedure. It come in as 11/22/2005.
I tried to format this date using:
=Format(Fields!DATE_RECEIVED.Value,"mm/dd/yy"). The date returned to me was:

Jeremy
12/7/2005 3:01:02 PM

Hi Donna,

You need to capital M's for month as follows:

Format(Fields!DATE_RECEIVED.Value,"MM/dd/yy")

[quoted text, click to view]

VonderBurg
12/7/2005 3:21:12 PM

What I did to fix this, under the properties of the text box or field
display change the format code to "d".

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : formating dates