This is absolutely great!
But, how to get rid of negative results? I don’t want to see the negative sign though!
1 Like
Once you configure a column as Date in Glide it should reload from the spreadsheet and just use the underlying date there, ignoring the format. That can take a little bit, depending on how big your spreadsheet is. Is that not what you see? Are you sure that the column in Google Sheets contains dates, and not text?
1 Like
Hey @Mark
EU FORMAT column in google sheet was formatted as date as you see below.
I needed it not being recognized as date in Glide but in text in order to show data in actual EU format and I used my DateUSA array column to operate In Glide like ordering and so on as in a EU format wasn’t recognized.
Now this makes no sense as new date columns in a Glide are universal and presented in local formats depending of local preferences. This is great! and a big step in the right direction. But we have to rebuild all our dates formats workarounds we used when Glide didn’t recognized other formats different than USA.
I was just trying to warn that maybe some Gliders are trying to convert those text columns presenting EU format to the new international, Glide support for date columns. It won’t work. You must start from an USA format date to make it right. When you convert a text data column presenting EU FORMAT dates to date it make some mistakes as you can see in my previous post.
Thanks for your attention and again my congrats for all the work!
3 Likes
@DareSteps when you say “no negative sign”, you mean the minus sign before digits? If so you can change that in the editor.
Is this what you mean ?
I’m still playing around with one negative figure. I’ll have it fixed tomorrow.
Exactly that is what I meant, the negative sign although I found how you got rid of it somehow complicated But hopefully one day I will find a way. Thank you for your reply 
1 Like
Just download my dummies guide. I’ll be adding more math tricks and comparisons.
Where can I find your guide to download it?
1 Like
Scroll up. It’s called idiots guide.
Hey, I am unable to use Math for calculating Time difference between 2 columns. Can anyone pls guide if i am missing something or is it a bug?
Why are your check out and check in time shown in math type?
1 Like
Hey @ThinhDinh, Just found that it is calculating in Days. So need to *24 to convert it to Hours.
Thanks for your response!
2 Likes
Yes now I can calculate days before birthday without. Requiring a person to enter their Last birthday.
Will be adding to it dummies later on.
Please share your app and tell me where that date column is.
Sending you in PM…
(now - A) - 1
Check out the app to see what A stands for.
To remove the negative sign before days elapsed, please use this formula. -0 is rendered as 1 for some reason by Glide (probably because it’s reading the same input just in reverse order). So just add - 1 to the calculation to get the days elapsed right.
Hours elapsed is a different kettle of fish. I have tried various permutations but without success as I can’t remove the decimals.I am sure there is much easier way.
I can’t find a way to use the result between two dates, as an increment in a specific column per user.
I can solve it on google sheet, but I wanted to test on the glide data.
But thanks anyway.
My guess is probably it is not seen as a number, but as a date value so increment is not possible.
Yes, it surely is. At first I thought that by subtracting dates I could get the result in number but no. Anyway, no problem. Thank you very much
Do you increase them by integer numbers? I imagine a long workaround would be having a further math column to “duplicate” that math column (possibly multiply by 1), then use that column for increment.