Wednesday 27 February 2008

Working with Dates in Reporting Services

I was trying to re-format the dates in SQL Reporting Services with seems to have its own default formats; I found this article which was quite helpful:
Working with Dates in Reporting Services

Basically you can use either:
FormatDateTime(Parameters!Date.Value,1)
(Note: the number represents the desired format – it’s quite limiting as it only has four formats only)

Or

Format(Parameters!Date.Value,"dd-MM-yyyy")
The second string parameter represents the desired format which can be anything you wish for.

Enjoy.

The link to my original post: Working with Dates in Reporting Services

1 comment:

Anonymous said...

Thanks buddy :)