Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login
Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Tek-Tips LinkedIn® Group

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...you guys have given us a way of asking a question and getting some very timely feedback from other users so we don't have to re-invent the wheel time and again..."
More...

Geography

Where in the world do Tek-Tips members come from?
Click Here To Find Out!

Tek-Tips Shirts!

Get Tek-Tips Swag
Get your
Tek-Tips Forums
SWAG here!
Home > Forums > Programmers > Reporting Solutions > Microsoft SQL Server: Reporting Services Forum

Formatting a date to show just the month Helpful Member!(2) 

thread1462-1639396
Read More Threads Like This One
aztech (IS/IT--Management)
23 Feb 11 14:00
I am trying to format a date to display just the month name spelled out.  Currently, it is just returning it as the number.  I tried the following, but instead of the month name, it returns "MMMM".

=Format(Fields!Month.Value, "MMMM")

I should also mention that this is a calculated field called "Month" as follows: =MONTH(Fields!ArrivalDate.Value) I also tried the format here, but it still just returned "MMMM".

Thank you.
aztech (IS/IT--Management)
23 Feb 11 14:14
I also tried =MonthName(Fields!ArrivalDate.Value), but that didn't work either.
Helpful Member!  DaveInIowa (Programmer)
23 Feb 11 15:39
Have you tried?
=MonthName(Fields!Month.Value)
or
=Format(Fields!ArrivalDate.Value, "MMMM")
Helpful Member!  mstrmage1768 (Programmer)
23 Feb 11 15:48
It sounds like your ArrivalDate field is not of the DATETIME type when it gets to the report.  You can try converting it to a DATE and then formatting...

=FORMAT(CDATE(Fields!ArrivalDate.Value), "MMMM")

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
C#.NET Programmer
 
aztech (IS/IT--Management)
24 Feb 11 9:33
Thanks DaveInIowa, your solution worked.

Also, thanks to mstrmage1768 for your response. The field was coming over as a DATETIME field, but numeric instead of alpha.  I was just trying to get it to convert to alpha.
Read More Threads Like This One

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Microsoft SQL Server: Reporting Services

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close