Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSRS Format date from YYYYMMDD to MM/DD/YYYY

When I run the report, the date shows in format YYYYMMDD but I need to convert it to format MM/DD/YYYY

For example: 20150213 - expecting result 02/13/2015

The expression below does not work. Suggestions?

=Format(Fields!InstallDate0.Value,"MM/dd/yyyy")
like image 375
user3711442 Avatar asked Feb 13 '15 00:02

user3711442


1 Answers

It looks like InstallDate0 is a string, not a date. Convert it to a date first, then format it:

=Format(CDate(Fields!InstallDate0.Value), "MM/dd/yyyy")
like image 195
Chris Latta Avatar answered Sep 21 '22 19:09

Chris Latta