Tasks/Calls Due Date colors based on GMT instead of user Timezone

💬 General Discussion
1

Had this issue in 7.2.x, currently running 7.4.3 and still have the same issue.

Due dates for tasks / calls are supposed to show in Orange color if the due date is today. However sometimes several of my tasks / calls with a due date for tomorrow are shown in orange, or tasks with a due date for today are shown in black. I did some research in the modules/Calls/Call.php coding and notice that today’s date and due_date are stored as db dates using $timedate->nowDb() & $timedate->to_db() functions.

Now I’m not really familiar with the SuiteCRM coding and this $timedate object in particular but it looks like these functions generate GMT times rather than the time in the user’s specified timezone. That explains why some of my tomorrows dates are shown in Orange as I’m in GMT-8 timezone (which is set in the User’s settings and is also my system’s timezone), and GMT is already 1 day ahead of my current date.

In the attached file I’ve shown an example of scheduled calls. The screenshot is made on the 20th 2PM in my timezone (GMT-8). The first scheduled call is shown in orange which is correct. However the other call is shown in black as the start time is set for 4:15PM. At 4:15PM in my timezone it’s already a new day in GMT timezone and therefore the tasks shows in black.

Is this a bug in the SuiteCRM coding or could there be another timezone setting on my system that I have missed?

2

Just tested this on a fresh installation of Suite 7.5 running a WAMP server (as opposed to my production suiteCRM which is running on a Linux server). Got exactly the same in 7.5, see the screenshot below.

Now, the above screenshot is made with the user’s timezone set for PST, GMT-8:00, timezone. For comparison I’ve also made a screenshot with the user’s timezone set for GTM-0:00 timezone as below.

Now the Start Date is automatically shown in GMT time too, so according to these times to colors are done correctly. However as shown in the first screenshot, when in PST timezone, the Start Dates are adjusted correctly to the right timezone, however the colors stick to GTM timezone…

My users are complaining about this as they really use the colors of planned activities to get an overview of what’s on their schedule for the day, but everything that’s scheduled later in the afternoon shows as tomorrow’s task.

3

Really no one experiencing the same problem?? Or maybe let me ask it differently, does this work properly for anyone (that’s not residing in GMT timezone and at least far enough out e.g. North America, to notice this issue)?