How to make my date/time fields stop changing

Ask for Help
1

Hello, Gliders,

I’ve seen many date/time field questions covered here, but there are so my changes to Glide since the last time I worked in it, that I’m not finding what I need.

I guess that I have a time zone issue.

  • I have an excel spreadsheet that contains event start and stop times that are correct for my local time zone.
  • When imported into glide tables, the times are jumping 6 hours ahead so all events are wrong. I see the “respect time zone” check box for the column, but it’s too late for that–they imported incorrectly.
  • How do I get my correct local times to import into glide tables.
  • If I can’t, what the heck do I do send those time fields 6 hours into the past?

Thanks for your help,
Mona

2

Do you mean Google Sheets? Or an Excel file that you imported to Glide later?

I’m not sure if you can do something with the already imported data, but you can add a math column with the formula: T - 6/24 with T being your original time to get it back.

1 Like
3

It is an Excel spreadsheet that I imported in a new “legacy” account app.
I’ll try that formula.

Thanks,
Mona

1 Like