The Microsoft Dynamics CRM connector accepts date/times in any of the following formats:
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.
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).