[Vtigercrm-developers] created time > today

[Angelo Paglialonga]

Hi Rubén you could have  problems with daylight saving if you change utc in config file, it happened on vtiger 6.x before.
All the best

_______________

Angelo Paglialonga
Consulente per soluzioni CRM ad alto ROI.

Telefono: 3386077866
Web: https://www.angelopaglialonga.com


> Il giorno 30 lug 2022, alle ore 00:05, Rubén A. Estrada Orozco <rulotec1 at gmail.com> ha scritto:
> 
> 
> If you have users in different timezones, I don't see what difference it would make to have your db in UTC vs anything else. Why do you think it would be better to stick to UTC, Alan?
> 
> When all your users are in the same time zone (in the case of my clients that's almost always the case), then I like to see the exact same values when I do a query vs when I see the value displayed in the UI. It's easier for my brain ;)
> 
> Saludos
> 
> Rubén
> 
> 
>> On Fri, Jul 29, 2022 at 4:27 PM Alan Lord <alanslists at gmail.com> wrote:
>> On 29/07/2022 16:41, Rubén A. Estrada Orozco wrote:
>> 
>> > When possible, use the same timezone in config.inc.php and in the 
>> > usrers' calendar config.
>> 
>> Oooh - I think this is wrong advice.
>> 
>> It's not a good idea if you have users in different timezones.
>> 
>> Everything _should_ be stored on the db as UTC. Then all users see the 
>> correct time *if* their profile is configured correctly.
>> 
>> This issue sounds like maybe there is an issue with either timezone 
>> conversion in the list filter, or a DATETIME / DATE conversion - meaning 
>> the hours are being lost or added...
>> 
>> Al
>> _______________________________________________
>> http://www.vtiger.com/
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20220730/fa0d0a4d/attachment.html>