Date Format in Reporting Services

0 votes
asked Aug 17, 2010 by jennifer

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

Is this possible?

1 Answer

0 votes
answered Aug 18, 2010 by jimconstable

Something like this expression.

= Format(DateTime.ParseExact("20100804", "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture), "'Day 'dd' , Month 'MM', Year 'yyyy")
Welcome to Q&A, where you can ask questions and receive answers from other members of the community.
Website Online Counter