UPDATE: I changed the query function from {Date}=TODAY(), which seems to ignore the user’s time zone, to just sending the query {Date}='2021-03-04T00:00:00.000Z'. It’s a couple extra steps pre-query to get the current day and format it correctly, but...

I know this is an old topic, but I’m new to Airtable and it’s just maddening. I’m in California, and it’s 7PM on March 4. I run an API call to update a record using a {Date}=TODAY() query, and the record for March 5 is updated. If I’m on a computer s...