Disable Time Zones

[livewire]

I have integrated ESPOCRM with my website so when a user registers all the details are manually entered to the Leads table with the Local Time.

The problem that im having is on my leads list the Created At and Modified date shows a future date. For an example i have set the Time zone to Asia/Colombo in both admin and user settings. And my server time is also set to the same. So now when a user registers the Created at and Modified date shows as Tomorrow along with the time instead of showing the proper date and time.

Can someone please tell me how can i disable the time zones so it will directly show the date and times or is there a workaround for this?

Thanks

[tanya]

Hello
Do you set Created At and Modified At fields, or crm does it?

[livewire]

i set the field values through a query

[tanya]

Set datetime in UTC timezone