During validation, we see a difference in the Time of the Timestamp but dates are matching. This could be difference in the Timezones on Celonis and on the client's system.

Hi @Sridhar Turaga,

I usually do it in transformations like this:

UPDATE "ACTIVITIES"

SET "EVENTTIME" = TIMESTAMPADD(HOUR, 5, ("EVENTTIME"))

This could be due to the sorting. Read this article: https://docs.celonis.com/en/activity-table-sorting.html

Otherwise follow the suggestion above, to add to the timestamp. Be also aware about what information you upload, and if you need to take winter and summer time into account.

Hope this helps.