Dear sir,
I queried report to be CSV file and compare time in glide data base and found there are some big errors. Please check in my attached images.
Can you check if the Respect time zones option is checked on both date columns?
Yes, it was checked. Is it no need to be checked? Do I have to uncheck it?
And what happened if I uncheck the Respect time zones? I am living in Thailand. Is there any effect my recorded time?
So, it means if I check the Respect time zone. It would create this problems, right? But it makes confusion from that name “Respect time zone”.
You recommended to uncheck it, right?
I don’t think @MaximeBaker suggested making any changes yet. Just trying to understand how you have things set up right now.
If ‘Respect Timezone’ is checked, I believe that means UTC/GMT time is what gets stored, and the time that is shown to you respects whatever timezone you are currently in. That means the time I see in the US would be several hours different from the time you see in Thailand for the same date and time in your data. Think of it this way, if you schedule an online meeting with someone on the other side of the world, each person would need to know the start time respective of where they live. If they both saw 10am as the start time, one person would be half a day late or early to the meeting. Instead, by selecting ‘Respect Timezone’, each person sees the start time of the meeting respective of their local time.
I see that Thailand is GMT+7 for the timezone. I can’t quite tell by your screenshots, but is the difference 7 hours or do you consistently see a different number of hours from the time in the table and the time in the CSV?
2 Likes