Hello, When troubleshooting a user, it can be helpful to know their system configuration. [image] Link for YC https://Agent.manun2.repl.co

Hello @Darren_Murphy Yes, anyway a YC column with a ‘date-time’ type necessarily arrives in string format (see the readme) so you have to do a ‘new date’. the problem is not the format (short, medium, long) but depending on the regions mm / dd / yyyy or dd / mm / yyyy or other

The problem here Darren is how Glide reads/handles the date, how the user sees it and how JS works with it. If I’m in Latin America, my date format is dd/mm/yyyy and if this code is executed I will receive an error in my YC column although Glide shows it perfectly. Example 1 t = '22/3/2021' ; // March 22, 2021 return new Date(t) // Returns “Invalid Date” Example 2 t = '12/3/2021' ; // March 12, 2021 return new Date(t) // Returns “Fri Dec 3 2021” - wrong date! JS does not have a Date type as variable unfortunately, any Date value is treated as string :face_with_thermometer: Saludos!

Hi friends, there is an open discussion for the problem of dates, it is good if we continue on the right subject. [image] Date Hell Ask for Help Hello @Mark Is it possible when using the “date-time” type that glide does a conversion from the regional format to the “us” format automatically (or at the limit to the ISO format, because I think that is to accept by new Date(…)). Because my browser is in French, so the format is in dd / mm / yyyy except that if I send a Date column directly to YC (for example 15/8/2021) and I do a Let x = new Date (date.value) I get an invalid date error, logical since js is in “us” format. And if possibl…

[image] gvalero: The problem here Darren is how Glide reads/handles the date, how the user sees it and how JS works with it. Just to humour me, can you please try this and let me know the result? Set your Glide date column to “medium” format, so it displays like “September 1, 2021, 1:18 AM” Create a template column to lock in that format Pass the template column to a YC column that tries to turn it into a date object using new Date() That works fine for me, but maybe as you say there might be regional variations that break it. I’m curious to know. PS. In my region, it’s also customary to use dd/mm/yyyy, but personally I would never use that format - or it’s ugly cousin mm/dd/yyyy. :wink:

@Darren_Murphy here you have: 1- Using en-US format (mm/dd/yyyy). I set my web browser to English and everything is ok: [image] 2- Using sp-419 (format dd/mm/yyyy). I set my web browser to Spanish and problems appear: [image] Let me finish my code to find/handle several formats and I will share it to test it. Feliz día!

in fact, nobody tested my code :stuck_out_tongue_winking_eye: :joy: :rofl:, because I solved the problem of the format according to the country dd/mm/yyyy mm/dd/yyyy, … and the format short, medium, long :stuck_out_tongue_winking_eye: :stuck_out_tongue_winking_eye: [image] Date Hell Ask for Help I share with you the code I made to test the Glide JS conversion. There are 2 two scripts: for a Date column for an Array Split (depends on the 1st script) The idea is to come and go and confirm the conversion. [image] [image] Script 1, Date Column Test YC https://Date-Test.manun2.repl.co Source https://replit.com/@ManuN2/Date-Test?v=1 Script 2, Array Test YC https://Date-Test-Array.manun2.repl.co Source : https://replit.com/@ManuN2/Date-Test-Array?v=1 Please give me a feedb…

Ufff … I didn’t know that :rofl: Let me come back to my home and I will test your YC

ah, now I see. The problem is that new Date() can only parse a human readable date if it’s in in English, yes? Maybe you need to pre-process your dates by first passing them through a YC translate column - just kidding :rofl: :rofl: If only everyone could agree that the only truly sensible date format is yyyy-mm-dd, then all these problems would evaporate. Dates are such a PITA :nauseated_face:

[image] Darren_Murphy: If only everyone could agree that the only truly sensible date format is yyyy-mm-dd, then all these problems would evaporate. We would need to start a campaign for this, get 100 million signatures maybe :rofl:

hola @Manu.n here my tests using your code, there is no good news, don’t hate me :innocent: I’m using dd/mm/yyyy format (Spanish): With short, it works fine: [image] With medium or long, an error appears :face_with_raised_eyebrow: [image] [image] Am I doing anything wrong or JS is doing its job unfortunately? Saludos!

Agent for information

Ask for Help

Manu.n September 1, 2021, 6:40pm 68

in fact, nobody tested my code , because I solved the problem of the format according to the country dd/mm/yyyy mm/dd/yyyy, … and the format short, medium, long

Topic		Replies	Views
Date format locale struggle: sheet vs app Ask for Help	42	2908	February 13, 2022
Date Hell Ask for Help custom-code	22	1922	September 16, 2021
Feeling Awesome with the JavaScript Column! - Thanks Glide Ask for Help	28	1498	June 11, 2023
Hello, and, On Extending Glide with Google Apps Script Ask for Help	36	5232	February 27, 2022
🆕 Format Date Plugin General	58	2885	August 22, 2022

Agent for information

Related topics