Search code examples
sql-serverdatereporting-servicesformattingbusiness-intelligence

SSRS - Using Date format that is not built in

I am working on a report in SQL Business Intelligence 2008 that has a table where one cell must contain a Date value (not DateTime, so just month, day, and year). Right now the expression for that cell would be as follows:

=Fields!MyDateValue.Value

The problem I have is that this date must be displayed in the format dd-MMM-yyyy, eg January 1, 2000 would be 01-JAN-2000. I was looking through the formats available in Properties->Number, and this format does not seem to be built in. Is there a way to get the cell to display the date in this format?

Solution

  • This works for me:

    =Format(Fields!MyDateValue.Value, "dd-MMM-yyyy")

    For upper case month, as you indicated:

    =UCase(Format(First(Fields!order_entry_date.Value, "ReportMain"), "dd-MMM-yyyy"))