DateTime and Time display values

The following describes the DateTime and Time values returned by a Load request from the CRM On Demand Connector.

Using Web Services v1.0

For Web Services v1.0, the time value returned by the SOAP response is the same as what was entered or displayed on CRM On Demand; for example, a CRM On Demand Account record has Last Call Date = 3/30/2013 07:15 AM. The DateTime value returned by the Load request is the same - <LastCallDate>03/30/2013 07:15:00</LastCallDate>

Using Web Services v2.0

For Web Services v2.0, the DateTime or Time returned is based on a timezone converted to UTC (offset = 0) value; for example, the same CRM On Demand Account record with Last Call Date = 3/30/2013 07:15 AM, might have a Load request return a different value like <LastCallDate>2013-03-30T12:15:00Z</LastCallDate> if the timezone is “(GMT-05:00) Eastern Time (US & Canada)”.

Where is Timezone Configured?

A timezone can be configured on the CRM On Demand UI by navigating to the following links:

  1. Admin -> User Management and Access Controls -> User Management -> <user_name>
  2. If the above is not defined, then Timezone is taken from: Admin -> Company Administration -> Company Profile.