Date Format in Reporting Services?

Question

I need to convert this value using expressions in reporting services From 20100804 to Day 04 , Month 08, Year 2010 Is this possible?

Answer 1

When dealing with text manipulation, when it becomes a too complicated in SSRS, I'd recommend accomplishing the task in SQL. It's faster and sometimes easier to deal with and maintain.

Regardles, yes, what you're asking for can be done. First, you want to make sure that you're dealing with a string. If "20100804" is not a string, use Cstr() to convert it to one. Let's say the date is store in the column "FullDate". Use the expression =CStr(Fields!FullDate.Value).

Next, we'l target the numbers needed to end with the result you're looking for. You can grab the first four characters for the year, the next two for the month, and the last two for the day.

This will be done with the text functions: Left, Right, and Mid.

We'll grab the year with Left(Fields!FullDate.Value, 4).

We'll grab the month with Mid(Fields!FullDate.Value, 5, 6).

We'll grab the day with Right(Fields!FullDate.Value, 2).

Lastly, we can put it all together by concatenating the strings and building the final result we want:

"Day " & Right(Fields!FullDate.Value, 2) & ", Month " & Cstr(Mid(Fields!FullDate.Value, 5, 6))" & ", Year " & "Left(Fields!FullDate.Value, 4)"

The above expression, will return the literal value:

Day 04, Month 08, Year 2010