1
Vote

Valid Issue with Receipts.

description

I added a receipt but in the format of 1101983 rather than say 1/19/1983. Appears to be a simple validation issue - need to keep people from entering bad date values. I received an error as follows:
The error occurred in the Function:
btn_SaveClose
Error Description:
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
Stack Trace:
at IMS_Cls.clsDatabase.ExecuteProcedure(String strStoredProcedure, clsDBIParameterCollection colParams) in C:\Dev\deploy\2.02.01\IMS_Cls\IMS_Cls\clsDatabase.vb:line 1025 at IMS_Cls.clsDatabase.Record_Save(DataRow& objRow, Int32 iUser, DataRow objRow_old) in C:\Dev\deploy\2.02.01\IMS_Cls\IMS_Cls\clsDatabase.vb:line 755 at IMS_Cls.clsForm.Save(Boolean& bReload, DataRow objRow_new) in C:\Dev\deploy\2.02.01\IMS_Cls\IMS_Cls\clsForm.vb:line 588 at IMS_Cls.clsForm.hdnToolbarAction_ServerChange(Object sender, EventArgs e) in C:\Dev\deploy\2.02.01\IMS_Cls\IMS_Cls\clsForm.vb:line 387

comments

davidshq wrote Apr 22, 2010 at 4:52 AM

The same error occurs if I enter bad data into the invoices date field.

wrote Feb 14, 2013 at 2:22 AM