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")
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")
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With