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.
1 Like
Entered via Glide
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.
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!
1 Like
So the TRUNC math column solution in the other thread works?
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 can simply use the built in Now variable directly in your math column, like so:
1 Like
I used ROUND instead of TRUNC but yes, it worked!
1 Like
Got it. Thanks Darren!