Hello - I am using Reporting Services 2000 / SQL 2000 and have a problem with
the way input date parameters display on the report.
I have start and end date parameters and have set the report to English(NZ)
- if i enter 1-12-2004 and 1-12-2006, when these are displayed on the report
they are always shown in US format - ie 12 Jan 2004
to display the date on the report i use this code: ="Date range between " &
Format(Parameters!startDate.Value,"d-MMM-yyyy") & " and " &
Format(Parameters!endDate.Value,"d-MMM-yyyy")
any suggestions?On the report properties, change your report language to English(NZ).
Andy Pottersql
No comments:
Post a Comment