Search code examples
sqlreporting-servicesssrs-2012

Date format change SSRS

I have a view with a date column with this format : YYYY-MM-DD and I am using that column in a SSRS report but the final user wants to have something like this:

December 31, 2018

I am using this expression:

=FormatDateTime(Parameters!prmReportDate.Value,DateFormat.LongDate)

But I am getting this:

Monday December 31, 2018

I don't need the day. Is there a way to remove it?

Solution

  • Try something like this:

    =MonthName(Month(Parameters!prmReportDate.Value),false) 
& " " & 
day(Parameters!prmReportDate.Value)
& "," & 
year(Parameters!prmReportDate.Value)