Regional settings - Can't input date in dd\mm\yyyy format

M

Michael M

Hi All,

We are having issues entering dates in dd\mm\yyyyy format via PWA.
We have recenlty change the regional settings of our PWA instance to
English(Australia) from English(US). The following things where changed
1. Change the reginal settings on the server hosting PWA
2.Change the regional settings under the PWA site Action->site
Administration->Regional Settings.

All date look correct when viewing the in dates via PWA. I.e. they are
showing up as dd/mm/yyyyy.
We try to edit a project via "edit project properties" . We enter a data
field by using the Calandar tool and select the relevant date. The data shows
up correctly as dd/mm/yyyy. Once we click Save we get the error

"The project could not be saved due to the following reason(s):
The following date custom field has erroneous data: Approval
The value for the custom field is not a valid date, or it is outside the
range for dates, which is January 1, 1984 through December 31, 2049."

If we change the data format to mm/dd/yyyy and save, all works fine.

I have look at some logs and I do see the following error logged
06/22/2009 13:10:42 1 INF Current thread culture is English
(Australia), current thread ui culture is English (United States), installed
culture is English (United States)
06/22/2009 13:10:42 1 INF Changing current thread culture to
English (United States)
06/22/2009 13:10:42 1 INF Leaving function
Common.SetThreadCultureToInstalledCulture
06/22/2009 13:10:42 1 INF The current ui culture English (United
States) is NOT right to left

Any ideas how we can resolve this?

Thanks
Michael
 
R

Rod Gill

Do all servers have Regional settings as d/m/yy? I remember somewhere there
can be problems if they aren't all the same (including SQL Server).

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Resource Plan - Regional Settings dd/mm/yyyy 3
Forcing a date entry format of dd/mm/yyyy 1
How to enter a date in DD-MM-YYYY format 2
Date format DD/MM in application wrongly converted to MM/DD in Wor 2
Set Date format in Project Web Access dd/mm/yy (not mm/dd/yy) 3
Day of Week from dd/mm/yyyy 7
yyyy-mm-dd date format? 3
Help with date format mm/dd/yyyy vs. dd/mm/yyyy 3

Top