🤯 I cant with the dates!

[Lin_Altshuler]

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

[Lin_Altshuler]

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

[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.

[Lin_Altshuler]

Yes thats right. but I mostly write dates using this

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.

[Lin_Altshuler]

you can see these both column are filled using a glide action.
This is a GS:

This is a Glide Tabke:

I have the date column in the google sheet set as plain text.

[Jeff_Hager]

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.

[gvalero]

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 : 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!

[Jeff_Hager]

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

System/GMT Time - Solved!

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…

System/GMT Time - Solved!

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

[Lin_Altshuler]

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

[gvalero]

That right my friend Jeff!!

Anyone can know a lot reading those threads about dates issues.

Saludos!

[L.M]

For what it’s worth, I empathize . 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 to be worthy.

[gvalero]

Hola de nuevo Lin,

What you are suffering is the same (I think) what I did time ago:

Rank Date

Hola @Manu.n I can see you use the date format dd/mm/yyyy like any person in Latin America. May you test a possible bug I found with this format when anyone tries to write/change the hour in GDE manually? 1)- Create this 2 columns and write these values please [image] Later, try to change the time value in any row. I’m going to change the value 12:40:00 to 1:30:00 As you can see, the Date is 03/08/2021 (dd/mm/yyyy) and has to be read as 03 de Agosto de 2021 because my Regional Settings…

But I discovered that I must use Date Picker to test dates or create new ones and have the right date format I wanted.

As you can see, I tested using GT, not GS.

Sorry for my delay to reply fast, I’m outside of my house using my phone with low battery

Bye