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 …

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 wr…

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 versio…

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 Sp…

@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 univ…

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 brow…

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…

🤯 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	342	April 30, 2022
📆 Date/time formats General	82	7820	December 29, 2020
Date format locale struggle: sheet vs app Ask for Help	42	2685	February 13, 2022
Mode "calendar" Feature Requests	4	442	January 6, 2020
Month and Day swapped in date Report a Bug	8	743	February 6, 2023

🤯 I cant with the dates!

Related topics