<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto">Hi Rubén you could have problems with daylight saving if you change utc in config file, it happened on vtiger 6.x before.<div>All the best<br><br><div dir="ltr"><span style="border-collapse: separate; "><div style="word-wrap: break-word; "><span style="border-collapse: separate; "><div style="word-wrap: break-word; "><span style="border-collapse: separate; "><div style="word-wrap: break-word; "><span style="border-collapse: separate; "><span style="border-collapse: separate; "><span style="border-collapse: separate; "><span style="border-collapse: separate; "><span style="border-collapse: separate; "><span style="border-collapse: separate; "><span style="border-collapse: separate; "><span style="border-collapse: separate; "><span style="border-collapse: separate; "><span style="border-collapse: separate; "><span style="border-collapse: separate; "><div style="word-wrap: break-word; "><span style="border-collapse: separate; "><div style="word-wrap: break-word; "><span style="border-collapse: separate; "><div style="word-wrap: break-word; "><span style="border-collapse: separate; "><div style="word-wrap: break-word; "><span style="border-collapse: separate; "><div style="background-color: rgba(255, 255, 255, 0); word-wrap: break-word; "><div class="ApplePlainTextBody" style="font-family: Helvetica; font-size: 14px; -webkit-text-size-adjust: auto;">_______________<br><br>Angelo Paglialonga<br>Consulente per soluzioni CRM ad alto ROI.<br><br>Telefono: 3386077866<br>Web: https://www.angelopaglialonga.com</div><div class="ApplePlainTextBody" style="font-family: Helvetica; font-size: 14px; -webkit-text-size-adjust: auto;"><br></div></div></span></div></span></div></span></div></span></div></span></span></span></span></span></span></span></span></span></span></span></div></span></div></span></div></span></div><div dir="ltr"><br><blockquote type="cite">Il giorno 30 lug 2022, alle ore 00:05, Rubén A. Estrada Orozco <rulotec1@gmail.com> ha scritto:<br><br></blockquote></div><blockquote type="cite"><div dir="ltr"><div dir="ltr"><div>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?</div><div><br></div><div>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 ;)</div><div><br clear="all"><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr">Saludos<div><br></div><div>Rubén</div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Jul 29, 2022 at 4:27 PM Alan Lord <<a href="mailto:alanslists@gmail.com">alanslists@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On 29/07/2022 16:41, Rubén A. Estrada Orozco wrote:<br>
<br>
> When possible, use the same timezone in config.inc.php and in the <br>
> usrers' calendar config.<br>
<br>
Oooh - I think this is wrong advice.<br>
<br>
It's not a good idea if you have users in different timezones.<br>
<br>
Everything _should_ be stored on the db as UTC. Then all users see the <br>
correct time *if* their profile is configured correctly.<br>
<br>
This issue sounds like maybe there is an issue with either timezone <br>
conversion in the list filter, or a DATETIME / DATE conversion - meaning <br>
the hours are being lost or added...<br>
<br>
Al<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a></blockquote></div>
<span>_______________________________________________</span><br><span>http://www.vtiger.com/</span></div></blockquote></div></body></html>