How can I change the date format for TFS work item query results in Visual Studio 2010

Question

Using VS2010 with TFS and all the date columns in the query results are in US format (ie m/d/yyyy). Can I change this to the en-AU (Australian) format of d/m/yyyy? Or even the more useful yyyy-mm-dd?

Is there a setting for this or is this format hard-coded into the software. My OS datetime format settings are set for standard Australian formats

Update: should have mentioned, the datetime format in the actual work items is in the correct format, just wrong in the datetime columns in work items query results.

Answer 1

According to this, they say you can't

http://blogs.msdn.com/b/teams_wit_tools/archive/2008/02/05/faq-4-how-do-you-change-to-format-of-a-date-on-a-work-item.aspx

"you cannot change appearance of the date/time fields in the results list of a query."

but that is for TFS 2008.

Since the report is coming from Reporting Services, you might be able to change it on your RS server.

For Report Designer itself, the SQL Server language resource that is used in the report-authoring environment is determined by the language of the installation of Microsoft Visual Studio. For example, if you are running a Japanese version of Visual Studio, the Japanese language resource for Report Designer is used. If you are using a version of Visual Studio for which there is no close match in the SQL Server languages, the language resource for Report Designer and report definitions is U.S.

http://msdn.microsoft.com/en-us/library/ms156493.aspx