Fixed Asset Integration error: "String was not recognized as a valid DateTime"

Dawn Langlie - Click for blog homepageI recently had a support case, running a Fixed Asset integration with Integration Manager, where we received the following error:

DOC 1 ERROR: System.FormatException: String was not recognized as a valid DateTime.
at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
at System.DateTime.Parse(String s, IFormatProvider provider)
at System.Convert.ToDateTime(String value, IFormatProvider provider)
at System.String.System.IConvertible.ToDateTime(IFormatProvider provider)
at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)
at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType)

The date format in both the source file and Microsoft Dynamics GP are set to MM/DD/YYYY.  We verified that the regional settings are set to English (United States) and the Date format is MM/DD/YYYY.  We also verified that the Server Properties in SQL are set to English (United States).

As this integration utilizes eConnect, we then looked at the Identity in the eConnect COM+ Application and this was a different user.  eConnect will look at this user’s Regional Settings to find the Date format.  We changed the Identity to the user that we verified Regional Settings for and the integration is now working without errors.

I hope this helps save time troubleshooting this error.