3358172 - If You Compare the UI Versus Odata Outcomes You Notice That There Are Some Wrong Dates Through the System

If you compare the UI versus Odata outcomes, you notice that there are some wrong dates through the system.

SAP Cloud for Customer

1. Go to the affected BO (let's use Sales as an example)
2. Sales Quotes Work Center View.
3. Open a Sales Quote ID "201".
4. See that, for example, Start Date field is set as May 10th  
5. If you check this object through Odata: https://my000000.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/SalesQuoteCollection?ID=201

You notice that the date is set as May 9th.

OData API response does not consider User Settings for DateTime conversion. That is used only on UI but ultimately it is stored in UTC format.

OData API returns the data with UTC format, it is not changing the data but giving a different representation with required info that the data is in UTC 'with Z' at the last.

You can check a time converter tool in order to understand the difference further.  You can proceed transforming for the relevant field before use.

You can also access our Influence Portal and suggest a change in this scenario.

Date and Time of Records Imported Through Data Workbench Are Different Than Expected

Wrong; Date; UI; Odata; Mismatch; Day. , KBA , LOD-CRM-INT-API , OData API (C4C Only) , How To