Ok, I give up. I thought I had it figured out with the new computed date columns . I offset the time zone, save the new calculated date and then use that. works fine in a GS table. But Glide tables insert the format WRONG. I want to cry seriously [image] [image]

Anyone here knows what is going on :face_with_head_bandage:? @George-Glide @ThinhDinh @Darren_Murphy @Jeff_Hager

Can you confirm if the same things that you demonstrated in your video also happen if you use a date picker…or I think you can get a date picker to show up in the data editor to select dates as well. Also, what happens when you manually type the dates using YYYY/MM/DD instead? I suspect that part of the problem is that you aren’t typing in a true ISO formatted date. You are typing in a date that is ambiguous depending on different regions. I think that underlying unformatted value is stored behind the scenes, which can be hard to parse apart if you meant MM/DD or DD/MM. Using a date picker stores the ISO version of the date time which is an international standard and should work regardless of region. Just to be clear, you can type a lot of random things into a date column and it will do it’s best to convert it to a date. Key words being “it’s best”. For example, you can type ‘3 months from now’ and it will give you a date 3 months in the future.

Yes thats right. but I mostly write dates using this [image] and I have to write a calculated date that takes 2 hours from glides date in order to use the computed columns. Its all one big mess. I had it figured out in a GS table but now in a glide table it ignores the written format. When I write to a google sheet it takes the format from the sheet.

you can see these both column are filled using a glide action. This is a GS: [image] This is a Glide Tabke: [image] I have the date column in the google sheet set as plain text. [image]

Ok. I just wanted to at least rule that out as a potential issue. I haven’t dug very deep into all of the new plugins. I’ve been experimenting with mostly the javascript plugin. I would think that if you used the original computed columns, such as math and template, you could build a text version of the date in a consistent format that would be the same regardless of region. After that, I’m not sure but possibly you could pass that template date into the plugin. It’s extra columns, but I feel pretty confident with how well the original computed columns work.

Hola @Lin_Altshuler Well, I know what you are felling because I walked that painful way and following some advices and tips I could handle dates without headaches. I use the format dd/mm/yyyy too and understand your case. Rule #1: Glide uses the date format from user’s device. If the user has Spanish settings but lives in US, Glides will show the date with dd/mm/yyyy on screen. You can test it changing your web browser‘s regional settings. Rule #2: If you are using Google Sheets to save data, the date will be saved using GS’ setting (regional setting) so, check your GS to change it if you want to fix a part of problem. Of course, here is where the offset problems begins when user and GS don’t use same regional setting or have different time zones. Rule #3. It’s funny but very useful :innocent:: don’t write the date values manually in Glide Editor, instead, you must use the Date Picker even, while you are testing! If you do that manually, Glide thinks and uses the “US format” for everything and you will see and hate those annoying cases where December is confused with the day #12 for example. The final solution is more complicated (Jeff wrote a solution weeks ago and I use another one). Let me find the thread where we discussed this to help you a little more. Saludos!

@gvalero are these what you are referring to, or are you thinking if something else? [image] clock3 System/GMT Time - Solved! Project Showcase This is an extension of the request for System Time, please. There’s been a lot of questions for a while about how to get a universal time that can be shared for multiple users across multiple time zones. Most of you will know that any time your get a date/time from one of the glide special values, it will always be the user’s local time. But if you don’t know which time zone they are in, then you have no easy way to convert that date/time into something standard, like Greenwich Mean Time, to… [image] clock3 System/GMT Time - Solved! Project Showcase @Jeff_Hager, here is my solution for this issue although I think, both solutions complement each other. In my case, I have a Google Sheet with a timezone XX and I try to have on APP the time based on that GS timezone and not the user timezone which is used by Glide. If my GS is using “Europe/Berlin” timezone (GMT +01) and my APP has multizone users around the world (USA, Brazil, Spain or Venezuela) buying tickets or making a booking I’m going to need to have transactions timestamp based on my…

Have you tried doing these in a Glide table? because I’m not referring the the time zone offset that I was able to figure out, but to the dd-mm formats differences between a GS and a GT. all the computed columns in a glide table don’t recognize the date that is stored in a date column with my browsers format. I cant do anything with it

That right my friend Jeff!! Anyone can know a lot reading those threads about dates issues. Saludos!

For what it’s worth, I empathize :cherry_blossom:. You’re saving me hours, as I’ll not even try, but rather focus my energy on other features instead. Thks, Lin for that. Sorry for your lost time. You’ll find other values to add to your apps. This one does not seem ready yet to shine or cooperate. It needs more experience :slightly_smiling_face:to be worthy.

🤯 I cant with the dates!

Ask for Help

Jeff_Hager November 22, 2021, 4:18pm 9

@gvalero are these what you are referring to, or are you thinking if something else?

Topic		Replies	Views
Date/Time Ask for Help	2	366	April 30, 2022
📆 Date/time formats General	82	8229	December 29, 2020
Date format locale struggle: sheet vs app Ask for Help	42	2903	February 13, 2022
Mode "calendar" Feature Requests	4	467	January 6, 2020
Month and Day swapped in date Report a Bug	8	777	February 6, 2023

🤯 I cant with the dates!

Related topics