Datetime differences - Server side vs client side

Hello Community,

I have a reference table named MessageIntervalNumber which has parameterized values and two other attributes: StartDate and EndDate. Additionally, I have another table named LocalMessageIntervalNumber which is the client-side / local storage version of the first one and it has the same attributes.

When synchronizing data from server side to client side I have noticed that Null DateTime values are not the same in both tables.

Server-side query:

SELECT ID, ENDDATE FROM {MessagesIntervalNumber} ORDER BY ID

Client-side query:

Problem: 1900-01-01 00:00:00 (server) vs 1900-01-01 00:36:45 (client).


Maybe I'm missing something really (really) simple but has anyone ever noticed this behavior?

Hi Ruben,


Are the data type of the both attributes set as DateTime?


Regards.

Hi Paulo,

Yes, thet are. The local entity was created by clicking "Add entity from database..." and both attributes have the same data type DateTime.