Wrong date picked if working after 6pm

[spragucm]

Hello, If I'm working in the evening, say sometime after 6pm, the date that is selected in the time tracker is the current date. But, when I look at reports it shows those ours being contributed to the next day. After digging around in the redmine hours logged for the given issue, it appears that time_tracker assigned the next day. It's strange that the bookings show the correct day while reports and redmine show the next day.

This problem has been pervasive since I first started using this tool, and I hadn't mentioned anything because I hoped it would work itself out. Well, it hasn't; so can you please investigate.

[spragucm]

Ok, so another entry after 6pm is being added to the next day's time in the reporting tab. I ensured that all time entries were assigned today and they were. I then verified that no database information was showing tomorrow's date-using MyPhpAdmin-and no data has tomorrow's date. So, I believe the time tracker is looking at any value after 6 and assigning it to the next day. This is quite frustrating and annoying; please solve. Thanks in advance.

[jume-dev]

I think its a problem with your timezone difference, i am quite sure about the problem, but i wont find time to fix it untill the weekend. If you can give me more informations (like screenshots, etc), maybe i can find time earlier

[spragucm]

Here are the screenshots, including some that are filtered by date.

Also, I checked the time zone on every single account and even set them all to the same thing-one was set for mountain time while the rest are set for Pacific, and one wasn't set but she isn't a member of the project. Despite changing all of them to the same timezone as the server, the reporting still doesn't work.

Thanks for looking into this and sorry for coming across a bit harsh. I was a little frustrated after spending a while looking into this issue without being able to resolve it.

[jume-dev]

Do i understand you correctly that the bug occurs only in report view? Maybe you told before and i missed it, but please clarify.

[spragucm]

It appears that the problem is only occurring in the report tab, nowhere else.

[jume-dev]

ok, so there is a bug for reports, which doesnt correctly locate the dates from the database, but i couldnt find it yet. Problem is, that your database is located at utc (redmine standard), so every time after 6pm is in utc after 12pm and so basically a new day.

[jume-dev]

i tried to reproduce your problem, but i am not able to. The filtering is wrong, thats right and i dont have the time to fix this, cause this is quite tricky, i will transfer this in a new ticket.

But your problem from the first screenshot, cant reproduce that. Do you have any filters activated there? Oh, and try to delete your browser cache for redmine.

Btw would be nice if you get me the information from your database for the specific records. What are you timezone settings in the redmine application.rb?

[spragucm]

I'm don't understand your point about utc. My computer is on UTC-Pacific, so it should think midnight is midnight. My clock settings on the server and client computer are set exactly the same and all of the redmine users are set for UTC-pacific as well. Am I missing a redmine setting somewhere?

[jume-dev]

What about all datetime entry in the database? Which timezone do they have? Redine standard for here is utc, so if you havent set anything in redmines application.rb regarding this issue, these entries should all be utc.

[spragucm]

Ok, I looked in the bitnami/redmine-2.3.1-3/apps/redmine/htcdocs/config/application.rb file you pointed out. The default time zone was still set to central time and I'm on Pacific Time. After changing the timezone in this file, everything works.

thanks for your time. sorry this was a silly error on my side.