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).