Symptom
You find the exported time stamp from OData service is different from UI.
Environment
SAP Business ByDesign
Cause
System determines project time zone based on time zone in the basic settings of the user that creates the project, which can be maintained in UI with 'My Settings', Time zone.
How are the time stamps (e.g. PlannedStartDateTime) calculated?
When a user enters e.g. 01.03.2021 as start date (A1S layer), the system converts this into a time stamp (01/03/2021 00:00:00.0000000), and converts this from the project's time zone into UTC. If the project's time zone e.g. CET, this results in 28.02.2021 23:00:00.0000000 (AP layer).
Odata Service exports time stamps as they are, this means in UTC. This is different than the UI, which shows dates in project time zone.
Resolution
In order to interpret the result from Odata service to get the same result as on the UI one has to take both elements PlannedStartDateTime and PlannedStartDateTime TimeZoneCode into account.
Keywords
OData service, PlannedStartDateTime, Project, Time zone, UI , KBA , SRD-PRO-PMN , Project Management , Problem