Case Date/Time in Database is different from Case display..

[murugappan]

Hi,

Refering to Screencap1, the case detail show the time created as 10.35pm but the record in database (Screencap 2) shows it is create at 14:35 which 2:35pm. The stream data in the Note also captured the time as 14:35. The timezone in the CRM was set as "Asia\Kuala Lumpur" (Screencap 3). The timezone set in PHP in the host server appears to correctly set for ""Asia\Kuala Lumpur" (Screencap 4 and 5).

Need help on this urgently as our reporting seems to be inconsistent and may be affecting our workflow in the Advance Pack as well.

[yuri]

Hi,

It's stored in UTC. Regardless of php settings.

[murugappan]

Hi,

Thank you so much. Just needed to confirm. I understand this is done to maintain the universality of the application. Great work.