This article applies to:
ML8, MultiStore
The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value
|
|
Symptoms
After attempting to setup a store using a different default locale than en-US, the error occurs for certain admin functions such as creating coupons: The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value
Cause
The AppConfig: DefaultLocale has been set for a different locale but the web.config was not modified.
Solution
Modify the web.config to change the locale from en-US to the different locale desired. Modify the 'culture' and 'iuculture' values. It may also be necessary to modify the "DBSQLServerLocaleSetting" value as well depending on the currency used.
|