Wednesday, August 15, 2012

SSRS Format Date tips

Hi there!

Recently, I was working on a SSRS Report wherein I need to use the Format function of SSRS for date formatting.

e.g. Format(Parameters!Date.Value,"dd-MM-yyyy")

Note here, if you use "mm" (lowercase), then it won't produce the proper results, as it's case sensitive and we need to pass "MM" (uppercase)

I found the below link useful which describes more on Format function in SSRS - (A good read)
http://thavash.wordpress.com/2007/04/10/working-with-dates-in-reporting-services/

No comments:

Post a Comment