Team ID: dzOTuFSjeNjyZuZBUiEs
App ID: asDyVJMVFdcQYTer7Hnf
I’m in the process of migrating our timekeeping / invoicing app to a PostgreSQL backend. I’m having an issue storing and retrieving dates.
I have a user use a date picker (date only - no time) to enter date into a helper table as part of a time entry input. The date gets stored in the helper table as, i.e., 4/4/2024, 12:00:00 AM
This later gets written to my PostgreSQL table (the column is type date - but it doesn’t really matter if it’s timestamp or timestamptz, the result is the same) as 2024-04-04 but Glide reads 2024-04-04T00:00:00Z
Then, when Glide parses the date, it’s converted to local time, so I get 4/3/2024 at 8:00pm I only really care about the date, so for my purposes the date is wrong. It shows 4/3/2024 as the date in my app, even though the user entered 4/4/2024.
I’ve referred to this thread: Date filled does not match the date showing up in data. The issue I’m having seems to be caused by the same thing but I wasn’t able to find a fix there.