Subject: Date Format Issue
As you have changed operating systems you might find that the problem is in the international date settings in windows. When Domino is run as a service it uses the servers settings to formate the date, when the client runs it uses the client settings. Here is a piece from our FAQ at http://www.wfs.com
Frequently when installing the Server software (NT, Win200x) the default US date format is accepted, then the regional settings are changed to localized date format. This change does NOT change the default settings which the Domino Server uses when it runs as a service. So that a scheduled agent on the Domino Server will us one date format while the Regional settings are using another. This will result in dates being displayed incorrectly, or as an error. In addition the time limited demo may expire before expected or not run at all.
The solution is to edit the Windows Registry so that the System Default Settings conform to the date standard that you are using.
When Domino runs as a service it uses the settings in HKEY_USERS.DEFAULT\Control Panel\International to get its date format. Below is a bit of an explanation of the Registry, including an example of the settings for a German HKEY_USERS server.
Please look at these settings on your server and make sure that they are set correctly for your server’s country and date format. The main items to look for are:
Variable Setting
iDate “0” = MM/DD/YY
"1" = DD/MM/YY
"2" = YY/MM/DD
sLongDate set to appropriate format eg MM dd yy
sShortDate MM/dd/yy
Please note that editing the Windows Registry must be done carefully and we do not take responsibility for any changes that you make. The server will need to be shut down and restarted after the Registry is changed.
Locale Settings on Operating System Level
For Windows make sure the Regional Settings are properly set.
By default Notes Server runs with system account
Make sure HKEY_USERS.DEFAULT\Control Panel\International
On UNIX set LOCAL and TZ environment variable.
Lotus Notes/Domino uses those settings for
-
presenting text
-
presenting date and time
-
sorting
This affects Servers and Clients
Windows System Account for running the Server
It is recommended to run the Domino Server with the system account!
make sure Windows System Account has the right Regional Settings.
check HKEY_USERS.DEFAULT\Control Panel\International
the easiest way is to export settings from the actual user and modify the registry key before importing back.
The following is an example of the registry settings for a German server.
Windows Registry Editor Version 5.00
[HKEY_USERS.DEFAULT\Control Panel\International]
“iCountry”=“49”
“iCurrDigits”=“2”
“iCurrency”=“3”
“iDate”=“1”
“iDigits”=“2”
“iLZero”=“1”
“iMeasure”=“0”
“iNegCurr”=“8”
“iTime”=“1”
“iTLZero”=“1”
“Locale”=“00000407”
“s1159”=“”
“s2359”=“”
“sCountry”=“Germany”
“sCurrency”=“DM”
“sDate”=“.”
“sDecimal”=“,”
“sLanguage”=“DEU”
“sList”=“;”
“sLongDate”=“dddd, d. MMMM yyyy”
“sShortDate”=“dd.MM.yyyy”
“sThousand”=“.”
“sTime”=“:”
“sTimeFormat”=“HH:mm:ss”
“iTimePrefix”=“0”
“sMonDecimalSep”=“,”
“sMonThousandSep”=“.”
“iNegNumber”=“1”
“sNativeDigits”=“0123456789”
“NumShape”=“1”
“iCalendarType”=“1”
“iFirstDayOfWeek”=“0”
“iFirstWeekOfYear”=“2”
“sGrouping”=“3;0”
“sMonGrouping”=“3;0”
“sPositiveSign”=“”
“sNegativeSign”=“-”