AnsweredAssumed Answered

CRM connector date formatting

Question asked by bernadeta.konczak432071 on Feb 13, 2018

I have a CRM table which  has a DATE column declared as DATE only. My  XML query response profile  returns this date in yyyy-mm-dd'T'24:00:00Z format. The 24:00:00Z offset adds additional day to dates in the column. Do you know how to fix it? (I've tried changing field type on xml profile from yyyy-MM-dd'T'HH:mm:ssZZ to character, but it did not fix the problem).

Outcomes