Currently all timezones are stored in America/New_York, including in the database. Not cool.
Database data should be updated to convert to store everything in UTC.
Code should be updated to convert from the user's local time zone, selectable on log-in.
Month start/end (for queries) should be figured based on earliest September 1 to latest October 1.
This work should be done in any month EXCEPT September.
Currently all timezones are stored in America/New_York, including in the database. Not cool.
Database data should be updated to convert to store everything in UTC. Code should be updated to convert from the user's local time zone, selectable on log-in. Month start/end (for queries) should be figured based on earliest September 1 to latest October 1.
This work should be done in any month EXCEPT September.