Thread: Arithmetic overflow error

I have been pulling my hair out regarding the editcoupon.aspx in the admin
The error when attempting to save is

C#/VB.NET Code:

Arithmetic overflow error converting expression to data type datetime.
The statement has been terminated. 


The line is 254 but that is the execute command.
The real issue seems to be line 235

C#/VB.NET Code:

sql.Append("ExpirationDate=" + DB.SQuote(Localization.ConvertLocaleDateTime(CommonLogic.Left(txtDate.Text, 100), Localization.GetWebConfigLocale(), Localization.GetSqlServerLocale())) + ","); 


I know our database dates have changed from UK to US in our SQL upgrade. How can I get around this?

Yeah I spotted this bug too when I changed the locale from US datetime to UK

This seemed to fix it...

C#/VB.NET Code:

sql.Append("ExpirationDate=" + DB.DateQuote(Localization.ToDBDateTimeString(Localization.ParseNativeDateTime(txtDate.Text))) + ","); 


Fixed, perfect thanks.