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
Showing posts with label Parameters. Show all posts
Showing posts with label Parameters. Show all posts
Wednesday, 27 February 2008
Subscribe to:
Posts (Atom)