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
Wednesday, 27 February 2008
Working with Dates in Reporting Services
Labels:
format,
FormatDateTime,
Parameters,
report,
reporting,
reporting services,
SSRS
Subscribe to:
Post Comments (Atom)
1 comment:
Thanks buddy :)
Post a Comment