SSRS Format string to date time DD MMM YYYY HH MM

Question

Display in reporting services text box - data is grouped. Best way to format grouped data 20170518110610 to DD MMM YYYY HH MM?

I.e.

18 May 2017 11:06

Tried Text box properties - number - custom format - dd-mmm-yyyy hh:mm the result is the same 20170518110610

You should be able to do this using the SSRS interface. Just go to the properties of that text box and format it. — Rigerta, May 18 '17 at 11:38

score 3 · Answer 1 · answered May 18 '17 at 12:36

You have problems because 20170518110610 is a varchar. You need to convert it to date before format it.

Possible solutions:

1) Return a datetime not varchar from datasource (preferred)

2) Parse value in SSRS then format value:

=Format(DateTime.ParseExact("20170518110610", "yyyyMMddHHmmss", Nothing), "dd-mmm-yyyy hh:mm")

1 Answers1