Knowledgebase & FAQ

When I view dates in RecQuery-TC, they appear in American date format mm/dd/yyyy instead of Australian dd/mm/yyyy.

Symptom

Viewing any date field using RecQuery-TC browser client displays the date in United States format, i.e.: mm/dd/yyyy.

Cause

The locale settings on the server hosting the RecQuery-TC web site are set to US regional settings,
OR
The locale settings on the server hosting the database (i.e. SQL Server or Oracle) are different to the web server.

Solution

Windows 2000

On the server, go to Regional Settings in Control Panel. Ensure that "Your locale (location)" is set to the desired setting (eg. "English (Australian)") as shown below.

Click on "Set default..." and ensure that the locale is set to the desired setting (eg. " English (Australia)") as shown below.

Once you have made the changes, the server may need to be restarted for the changes to take effect.

Windows 2003

On the server, go to Regional & Language Settings in Control Panel. Ensure that "Your locale (location)" is set to the desired setting (eg. "English (Australian)") as shown below.

On the "Advanced tab" click on "Apply all settings to the current user account and to the default user profile" as shown below.

Once you have made the changes, the server may need to be restarted for the changes to take effect.

Back to FAQ index

 

  Back | Top
Site by Intelliweb Productions