[Vtigercrm-developers] created time > today

[Stacey Johnson]

The problem is how time is displayed in the record. When config has UTC and
user UTC +6 the record created time is displayed in UTC and that misleading
user.
It also messes up the filter... Solution would be adding displaying
time/date as per user time zone, or adding configurable function to a
filter such as 'createdtime (add_hours(+7h))' and accordingly changing
displayed time adding/deducting timezone difference

On Sat, Jul 30, 2022 at 4:27 AM 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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20220730/23479aeb/attachment-0001.html>