Sunday, March 11, 2012

DateTime Format

I have a database field that is in DateTime format... in my report I want to
stick this date in the middle of a string and display it... as MMM d, yyyy...
nothing I try seems to work... any ideas?Hello MER78,
You can use the Visual Basic Format() function like this:
=Format(Fields!YourDate.Value, "MMM d yyyy")
and of course you should be able to concatenate as you said:
=Fields!AnyData.Value & Format(Fields!YourDate.Value, "MMM d yyyy")
Hope this helps.
Rodney Landrum - Author, "Pro SQL Server Reporting Services" (Apress)
http://www.amazon.com/exec/obidos/tg/detail/-/1590594231/102-0081700-1383300
http://www.apress.com/book/bookDisplay.html?bID=365
"MER78" <MER78@.discussions.microsoft.com> wrote in message
news:32D29B62-ADAA-4A1F-B176-362E7088A7CA@.microsoft.com...
>I have a database field that is in DateTime format... in my report I want
>to
> stick this date in the middle of a string and display it... as MMM d,
> yyyy...
> nothing I try seems to work... any ideas?
>

No comments:

Post a Comment