Run this script against your Emerald database and it will fix
the date problem.
------------------------------------------------------
Update Operators Set DateFormatID = 5
Go
IF object_id('WebCheckOperator') IS NOT NULL
DROP PROCEDURE WebCheckOperator
GO
CREATE PROCEDURE dbo.WebCheckOperator @user VARCHAR(16)
AS
SELECT op.OperatorGroupID, op.OperatorID, op.Operator, op.Password,
op.Email, og.OperatorGroup, op.LanguageID, 0 AS CustomerID,
0 AS AccountID, DateFormatID, DateSeperator
FROM Operators op, OperatorGroups og
WHERE op.Operator = @user
AND op.Active = 1
AND op.OperatorGroupID *= og.OperatorGroupID
UNION ALL
SELECT og.OperatorGroupID, 0 as OperatorID, sa.Login, sa.Password,
sa.Email, og.OperatorGroup, -1 as LanguageID, sa.CustomerID,
sa.AccountID, 5 as DateFormatID, '/' as DateSeperator
FROM MasterAccounts ma, SubAccounts sa, OperatorGroups og
WHERE og.OperatorGroup = 'CustomerAccess'
AND sa.CustomerID = ma.CustomerID
AND ma.Active = 1 AND sa.Active = 1
AND sa.Login = @user
AND sa.Login IS NOT NULL
AND sa.Password IS NOT NULL
AND sa.Password <> ''
AND sa.RemoteAccess = 1
ORDER BY CustomerID ASC
GO
GRANT EXECUTE ON WebCheckOperator TO Emerald
GO
Delete From OperatorCookies
GO
------------------------------------------------------
------------
This is a user supported list. If you require assistance from IEA Software's
Support Engineers, please check out our Support resources at
http://www.iea-software.com/support.
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart