Hello all, I have two timestamp columns that show dates in South American format (dd/mm/yyyy). I want to get the difference in days between both. But every column I use (math or experimental date difference) regard the dates as mm/dd/yyyy rendering the wrong answer. Help…

Are those columns imported to Glide, or entered via Glide?

Could you please show a screen shot of the two columns in question, as well as the Math formula you used? I’ve never known a math column to give incorrect results for this.

Hello Darren, the first pic shows a date difference as if the date had a U.S. format (although I just saw that under US format, rows 3 to 5 should be 60 days, not 90. How weird!). The second pic shows how the math column renders “invalid op on date time”. Thanks for your time Darren. [a] [b]

Hello Darren, just in case so I don´t use your time, Thinh has just sent me a solution for the date difference. Thanks anyway!

So the TRUNC math column solution in the other thread works? [image] Extracting from an array Ask for Help Ok here’s my proposed solution. [CleanShot 2025-03-06 at 06.25.29] From the array, use this to get the array length. [CleanShot 2025-03-06 at 06.25.38] Use thi…

I can’t tell what type of column “Hoy” is, but I can tell that the values in that column are not Dates. They are strings that look like dates. And that is why you get the error in the Math column. If the only purpose of that “Hoy” column is to return the current date, then you don’t need it. You ca…

I used ROUND instead of TRUNC but yes, it worked!

Date difference

Ask for Help

ThinhDinh March 6, 2025, 11:54pm 7

So the TRUNC math column solution in the other thread works?

Topic		Replies	Views
Date math lacking precision Ask for Help	15	698	February 21, 2022
Different between 2 dates using Math and Day Ask for Help	4	725	August 30, 2022
🆕 Comparing Dates General	51	4526	January 14, 2022
Today and 14 days ahead Ask for Help	23	784	February 10, 2023
🆕 Date-time Math General data-editor	123	14179	September 27, 2023

Date difference

Related topics