CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2008-r2
Rosebud
Rosebud

Reputation: 589

SSRS Format string to date time DD MMM YYYY HH MM

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

Upvotes: 3

Views: 4127

Answers (1)

Mikhail Lobanov
Mikhail Lobanov

Reputation: 3026

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")

Upvotes: 3

Related Questions