garyditsch / three-sixity-five

Daily tracker for goals
0 stars 0 forks source link

The activity date submitted needs to be converted to GMT prior to insert #95

Open garyditsch opened 6 months ago

garyditsch commented 6 months ago

This doesn't appear to be the problem. At the moment (during the day hours between noon at 2:30 pm Eastern Time) the behavior is as expected both user the dev server and production deployment on vercel. Behaving as expected when accessed on laptop and iPhone.

In supabase the activity date is being stored as UTC appropriately.

Will test again once UTC turns over midnight as there may be an issue there?

garyditsch commented 6 months ago

So it is related to the GMT turning to the next day, because of the way the date is created. The date is selected from the day of year param and it just uses the time of day the entry is made. So when the GMT turns to next day, it's just showing early morning of the current day, not the next day.