Hi Team,
CK Birla raised an issue where for some leads Lead Categorisation – BFI activity time stamp shows time different to what in DB.
Sample lead – https://in21.leadsquared.com/LeadManagement/LeadDetails?LeadID=8bd166d3-2938-44f0-af18-0c58ed80fdc6&pageNumber=1
The activity was added Manually and not via API.
PFB:
Time stamp shows: 01st Oct 1:34 AM
However in Clone DB (They have access to it) it shows 30-09-2023 20:04, difference around 5.30hrs.
Analysis: Post checking with Dev could confirm that it is an expected behavior. We save the activity date time in DB in UTC format and UI it converts into
user time-zone and display it.
From the above screen shot, the user would have created the activity on UI on 1st Oct 1:34 AM. but in DB it stored in UTC i.e. 30th sept 20:04
I hope this helps.
Best,
Kiran
Kiran
