String was not recognized as a valid DateTime.Couldn't store <19/03/2020 00:00:00> in ShipDate Column. Expected type is DateTime

Epicor ERP 10
1

Hit this error when generate DO.

Application Error

Exception caught in: System.Data

Error Detail

Message: String was not recognized as a valid DateTime.Couldn’t store <19/03/2020 00:00:00> in ShipDate Column. Expected type is DateTime.
Inner Exception Message: String was not recognized as a valid DateTime.
Program: System.Data.dll
Method: set_Item

Client Stack Trace

at System.Data.DataColumn.set_Item(Int32 record, Object value)
at System.Data.DataRow.set_Item(DataColumn column, Object value)
at System.Data.DataRow.set_Item(String columnName, Object value)
at Script.GenDeliveryOrder(Int32 iSelected)
at Script.btnGenDO_Click(Object sender, EventArgs args)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at Infragistics.Win.Misc.UltraButtonBase.OnClick(EventArgs e)
at Ice.Lib.Framework.EpiButton.OnClick(EventArgs e)
at Infragistics.Win.Misc.UltraButton.OnMouseUp(MouseEventArgs e)
at Ice.Lib.Framework.EpiButton.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Inner Exception

String was not recognized as a valid DateTime.

Inner Stack Trace

at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
at System.Convert.ToDateTime(String value, IFormatProvider provider)
at System.String.System.IConvertible.ToDateTime(IFormatProvider provider)
at System.Data.Common.DateTimeStorage.Set(Int32 record, Object value)
at System.Data.DataColumn.set_Item(Int32 record, Object value)

2

What set that value? Customization, Method Directive, Data Directive?

3

Complete guess here, does the system’s culture settings match the datetime string format?

1 Like
4

I’ve struck that same error here when using the DMT on a server I didn’t setup. The regional settings were set to US, but the date format on the data was AU. everything looked ok in the first few weeks of January, it was not until we got to day 13!

5

Hi there,
Always use the The ISO 8601 format YYYY-MM-DD (2020-03-20).
That has never failed. Also, remove the time, I’m not sure Epicor accepts it on Date columns.

image

Regards,
PSE