Date Picker in US Format after SP2

Last Post 12 Apr 2007 07:09 PM by MGHarris. 2 Replies.

Author

Messages

MGHarrisNew Member

11 Apr 2007 03:58 PM

Updated SQL 2005 to SP2 and Reporting Services Date Picker now has dates defaulting to US format (MM/DD/YYYY) instead of our previous English-Australian (DD/MM/YYYY). Both the clients and server are set to English Australian regional settings in the O/S and the reports are composed for English Australian language. Reports have correct format in Visual Studio development and re-deploying them had no effect. Everything was fine under SP1 - not sure what is going on. Any ideas???

SQLUSANew Member

12 Apr 2007 03:52 PM

Sounds like a bug. It should follow the regional settings on the server or the client.

After doing some more analysis; I have found that if a datetime parameter prompt is placed after two parameters that cascade, then the correct date format (in our case English-Australian DD/MM/YYYY) is used in the Date Picker (probably due to the language settings in the client and report). Otherwise you get the US Date format (MM/DD/YYYY). This means that if you have datetime parameters on their own or even with drop downs, multi-selects etc.. then you could be in for trouble.