Date parsing for the Microsoft Dynamics CRM connector

Document created by RichardNotley941 Employee on Dec 19, 2016Last modified by mike_aronson on Dec 19, 2016
Version 3Show Document
  • View in full screen mode

The Microsoft Dynamics CRM connector accepts date/times in any of the following formats:

  • yyyy-MM-dd'T'kk:mm:ss'Z'
  • yyyy-MM-dd'T'kk:mm:ssZ
  • yyyy-MM-dd'T'HH:mm:ss


Note: HH = Hour in day (00-23); kk = Hour in day (01-24).  See the User Guide for more information on date/time formats.


Source data in any other format must be reformatted to one of these valid formats - e.g. using a Date Format function in a Map - prior to using the connector.


Common Error

Many dates are processed successfully, but some result in the following date parsing error:

com.boomi.connector.api.ConnectorException: Error in converter, couldn't parse 2016-12-19T00:01:02Z


In this case, the source format is: yyyy-MM-dd'T'HH:mm:ss'Z'.


Although this is not an accepted format for the connector, all date/times - other than those with '00' in the hours element - will be parsed successfully using the first of the valid formats (yyyy-MM-dd'T'kk:mm:ss'Z').  However, for '00' hour date/times, the connector will give the above parsing error.  (Reformatting the source data to one of the valid formats will eliminate this error).

1 person found this helpful