My input data is in the date format: DD/MM/YY. I have 2 parameters Start date and end date. The query runs fine and returns the data between start and end date.
The problem is that it converts the dates into MM/DD/YY. What it does is it converts 01/12/05 (1st December 2005) to display 12/01/2005 (12th January 2005).
Also when i export the data its format shows 12 as the date instead of month.
The server is in AUstralia and running on British format (DD/MM/YY).
Any help will be appreciated.
Thanks,
Nit
What's the client culture when you export the report? And what is the server OS culture? Does the RDL have a specified language setting?
We use the client culture when formatting the parameter value, and server OS culture when formatting the textbox value in the report (if there's no language specified in the RDL).
- Fang
No comments:
Post a Comment