Display day and month name in ssrs

Question

I have an example date of 4/29/2015 . I need to change the date format to " Wednesday,april 29,2015 . How to do this using SSRS .?

Answer 1

Assuming your date field has a date or datetime data type (otherwise you need a cast in your sql query), you can do this:

• Right-click the text field where your date and time is displayed, and select the properties of the text field:

• In the left pane, select "Number", then "Date" and select the desired format:

• Then you should see the date displayed as:

Answer 2

Your expected format ( Wednesday,april 29,2015 ) is not standard , so you will need a custom format :

 "dddd,MMMM dd,yyyy" 

So, the date 4/29/2015 will output Wednesday,april 29,2015 , which is closer to what you need than the standard D format, which will output Wednesday, April 29, 2015 .

Now that you have the correct format, you need to put it in the report.

There are 2 options:

I assume you have a datetime field called YourDate or a string field called YourDateString .

• In the expression:

  • =Format(CDate(Fields!YourDateString.Value), "dddd,MMMM dd,yyyy")
  • =Format(Fields!YourDate.Value, "dddd,MMMM dd,yyyy")

• In report item properties

  • Expression:
    =CDate(Fields!YourDateString.Value) or =Fields!YourDate.Value
  • Text field properties => Number => Custom => Custom format:
    dddd,MMMM dd,yyyy