Task Due Times Display One Hour Early?

[markb14391]

The due times for all tasks appear an hour early in the task list...a task due at 5:00 PM will show up being due at 4:00, for example. Opening the task to edit it shows the proper time in the detail view.

I have the proper time zone set (Eastern, GMT-5 +DST).

Is there a fix for this? Is anyone else seeing this?

Thanks,

Mark

[andopes]

Hi, Mark.

Are you sure the server where your sugarcrm is hosted has the correct time?

[markb14391]

Thanks for the reply.

I'll check the server time, but I don't think that's the issue for a few reasons. First of all, the times display properly elsewhere (detail view), and meeting times display properly everywhere. Besides, if I enter a time of 4:00 for a task, I wouldn't think that it should change depending on where the server is. If I'm saying something is due at 4:00, and I've already set my SugarCRM system to GMT-5 + DST, I wouldn't think that the server time should matter, right?

Is anyone else experiencing this? Any ideas for a fix?

Thanks,

Mark

[Mars]

Hi Mark, this happened to me too, but only in Tasks created after 31/03/2008.... I fixed it including this code in \include\ListView\ListViewGeneric.tpl

In line 139 put:

{if $col=='DATE_START'}
{assign var='fechatarea' value=$rowData.$col}
{/if}


line 173


{if $col=='TIME_DUE' && $fechatarea > '2008-03-31'}
{assign var='hora' value=$rowData.$col|substr:0:2}
{assign var='horamasuno' value=$hora+1}
{if $horamasuno<10}
0{$horamasuno}:{$rowData.$col|substr:3:2}
{else}
{$horamasuno}:{$rowData.$col|substr:3:2}
{/if}


{elseif $col=='TIME_DUE'}
{$rowData.$col|substr:0:5}
{else}
{$rowData.$col}
{/if}

Good luck!!!!

[markb14391]

Hi,

Thanks so much for the help! Unfortunately, those changes don't fix the problem for me. But I wonder if I'm doing it right. My file didn't even have 173 lines for example (it was something like 168, even after making the additions at line 139), so I wonder if we're using different versions of Sugar or something? Mine is Community Edition 5.0.0d (Build 3235).

I'll keep trying to figure out what I did wrong.

Best regards,

Mark

[markb14391]

BTW, are Mars and I the only ones who have run into this issue? Can anyone else let me know if you have too?

Thanks.

[cnaughton]

You are not alone. I am located in the US Eastern time zone, with Sugar set to the Eastern time zone, while my server is located in the Central time zone. All tasks show up as being due 1 hour before the entered due time for me.

[kpit]

This is related to the time zone settings on the server if they are not set correctly this can cause problems with date calculations in mysql and PHP Date calculations. The database datetimes are stored in GMT time. Date calculations are taken in account with several issues. Especially if the new timezone updated for the extended DST is not applied. Over all Server time does matter especially when dealing with other timezones.

Also how much time are you doing the aleart before the scheduled time. this could be another reason is it is set to remind 1 hour before.