Date format changes to MM/dd/yyyy when returned through Web Service
Posted on 2004-08-18
I have a crystal report for VS.net 2003 framework 1.1, developed as a web service that is displaying dates in system's default short date format (dd/MM/yyyy). When webservice returns the data the report changes the Date format to MM/dd/yyyy instead of systems default (dd/MM/yyyy), set through regional settings. so when i see the reports all the date fields are shown in MM/dd/yyyy format.
I have webservices and clients on the same machine. the database is on SQL Server 2000 which is also on same machine.
I am using Custom Style for all the date fields as I need the format to be the systems default short date as set by the user.
In current scenario the Regional Settings of the date format is dd/MM/yyyy. I have also tried culture entries in web.config but the results are same
Does anyone know how to handle this? Thanks in advance.