SAP Knowledge Base Article - Public

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

Reproducing the Issue

  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:

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.

See Also

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


SAP Cloud for Customer core applications 2305