Redmine

Same problem here, also on 3.3.0.stable. Workaround: I get correct results if I set the time zone in my account to the one used on the server.

Manuel Reinhardt wrote:

Same problem here, also on 3.3.0.stable. Workaround: I get correct results if I set the time zone in my account to the one used on the server.

I confirm, this turn around works perfectly.

Thanks Manu

This is related to #22320. Date filters now take care of timezones.

Workaround: I get correct results if I set the time zone in my account to the one used on the server.

Did you get incorrect results when leaving your timezone blank in your Redmine account?

hello,

I am also this problem .. Anyone know any way to fix?

Thanks!

I put my documentation in #16482-7, we are having this issue as well.
Is there more documentation that is needed that would help figure out the cause?

thanks,

We have this bug, with version 3.4.2.stable.

On our server, with the UTC timezone, the Query system generates SQL that seems to compare a date by time adjusted by the timezone in my preferences (PST): time_entries.spent_on >= '2018-01-09 07:59:59.999999' AND time_entries.spent_on <= '2018-01-10 07:59:59.999999'. I'm trying for January 9th, there, and MySQL presumably converts a date of '2018-01-09' to a datetime of "midnight".

On my notebook, set to PST, the query is correct: time_entries.spent_on > '2018-01-14 23:59:59.999999' AND time_entries.spent_on <= '2018-01-15 23:59:59.999999'. I get the records I'm looking for, on '2018-01-15'.

When I erase my timezone from my Preferences on the server, the problem goes away.

I could fix this myself, as soon as I figure out where in the Query system that line gets generated...

Hi,

I'm having the same issue. The provided patch will make it work but, is this the right way to go? Is there a way we could help to make this fix permanent into Redmine? (I'm sorry, I'm new to this issue queue)