Date Picker in US Format after SP2

Last Post 12 Apr 2007 08:09 PM by MGHarris. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
MGHarris
New Member
New Member

--
11 Apr 2007 04: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???
SQLUSA
New Member
New Member

--
12 Apr 2007 04:52 PM
Sounds like a bug. It should follow the regional settings on the server or the client.

Perhaps a hotfix out? Check on the Microsoft site.

Kalman Toth, Database Architect
SQL Server 2005 Training - http://www.sqlusa.com/ordertriplecrown
MGHarris
New Member
New Member

--
12 Apr 2007 08:09 PM
I have not seen a hotfix. However:

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.
You are not authorized to post a reply.

Acceptable Use Policy