# 🆕 Date-time Math **URL:** \ **Category:** General\ **Tags:** data-editor\ **Created:** [September 17, 2020, 5:47pm UTC](https://community.glideapps.com/t/date-time-math/15963 "2020-09-17T17:47:41Z")\ **Posts on this page:** 20\ **Page:** 3
**Author:** ![DareSteps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daresteps/32/11716_2.png) [@DareSteps](https://community.glideapps.com/u/DareSteps)\ **Post date:** [September 18, 2020, 4:27pm UTC](https://community.glideapps.com/t/date-time-math/15963/43 "2020-09-18T16:27:26Z")
This is absolutely great! But, how to get rid of negative results? I don’t want to see the negative sign though! ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [September 19, 2020, 12:39am UTC](https://community.glideapps.com/t/date-time-math/15963/44 "2020-09-19T00:39:58Z")
> [@darder](#): > > As yo can see in the video below it makes some mistakes. Only dates which are not legible as USA FORMAT are ok. 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? ---
**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\ **Post date:** [September 19, 2020, 2:06am UTC](https://community.glideapps.com/t/date-time-math/15963/45 "2020-09-19T02:06:58Z")
Hey @Mark EU FORMAT column in google sheet was formatted as date as you see below. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/5d669ba723aa078ddb4fac5cf368ca2e8db75366.jpeg) 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. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c54ab6f9a7c43ba60183f59814b07b90c8921f52.jpeg) 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! ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [September 19, 2020, 2:19am UTC](https://community.glideapps.com/t/date-time-math/15963/46 "2020-09-19T02:19:07Z")
@DareSteps when you say “no negative sign”, you mean the minus sign before digits? If so you can change that in the editor. ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [September 19, 2020, 2:27am UTC](https://community.glideapps.com/t/date-time-math/15963/47 "2020-09-19T02:27:44Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/231cc7d505b4eaa0cd7eda90bbe9232bae40cb97.jpeg) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/bfe6b6d0374d33a037a4a68be9926432fb418413.jpeg) Is this what you mean ? I’m still playing around with one negative figure. I’ll have it fixed tomorrow. ---
**Author:** ![DareSteps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daresteps/32/11716_2.png) [@DareSteps](https://community.glideapps.com/u/DareSteps)\ **Post date:** [September 19, 2020, 3:15am UTC](https://community.glideapps.com/t/date-time-math/15963/48 "2020-09-19T03:15:15Z")
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 🙏🏻 ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [September 19, 2020, 3:36am UTC](https://community.glideapps.com/t/date-time-math/15963/49 "2020-09-19T03:36:47Z")
Just download my dummies guide. I’ll be adding more math tricks and comparisons. ---
**Author:** ![DareSteps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daresteps/32/11716_2.png) [@DareSteps](https://community.glideapps.com/u/DareSteps)\ **Post date:** [September 19, 2020, 3:38am UTC](https://community.glideapps.com/t/date-time-math/15963/50 "2020-09-19T03:38:53Z")
Where can I find your guide to download it? ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [September 19, 2020, 3:40am UTC](https://community.glideapps.com/t/date-time-math/15963/51 "2020-09-19T03:40:42Z")
Scroll up. It’s called idiots guide. ---
**Author:** ![raghav\_khandelwal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/raghav_khandelwal/32/12492_2.png) [@raghav\_khandelwal](https://community.glideapps.com/u/raghav_khandelwal)\ **Post date:** [September 19, 2020, 7:41am UTC](https://community.glideapps.com/t/date-time-math/15963/52 "2020-09-19T07:41:59Z")
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? ![TIme 2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/4dc4f47a23702fe2f9b4aed3aa6e191b753cbb3a.png) ![Time1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/4a608df9d054ae5aab9988cc2692ed66ef591c0a.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 19, 2020, 8:33am UTC](https://community.glideapps.com/t/date-time-math/15963/53 "2020-09-19T08:33:43Z")
Why are your check out and check in time shown in math type? ---
**Author:** ![raghav\_khandelwal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/raghav_khandelwal/32/12492_2.png) [@raghav\_khandelwal](https://community.glideapps.com/u/raghav_khandelwal)\ **Post date:** [September 19, 2020, 8:51am UTC](https://community.glideapps.com/t/date-time-math/15963/54 "2020-09-19T08:51:27Z")
Hey @ThinhDinh, Just found that it is calculating in Days. So need to \*24 to convert it to Hours. Thanks for your response! ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [September 19, 2020, 11:19am UTC](https://community.glideapps.com/t/date-time-math/15963/55 "2020-09-19T11:19:55Z")
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. ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [September 19, 2020, 7:25pm UTC](https://community.glideapps.com/t/date-time-math/15963/56 "2020-09-19T19:25:47Z")
> [@darder](#): > > 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. Please share your app and tell me where that date column is. ---
**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\ **Post date:** [September 20, 2020, 12:29am UTC](https://community.glideapps.com/t/date-time-math/15963/57 "2020-09-20T00:29:29Z")
Sending you in PM… ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [September 20, 2020, 4:26pm UTC](https://community.glideapps.com/t/date-time-math/15963/58 "2020-09-20T16:26:03Z")
(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. ---
**Author:** ![Mariano\_Betta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mariano_betta/32/17895_2.png) [@Mariano\_Betta](https://community.glideapps.com/u/Mariano_Betta)\ **Post date:** [September 21, 2020, 8:42pm UTC](https://community.glideapps.com/t/date-time-math/15963/59 "2020-09-21T20:42:31Z")
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. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 22, 2020, 12:57am UTC](https://community.glideapps.com/t/date-time-math/15963/60 "2020-09-22T00:57:38Z")
My guess is probably it is not seen as a number, but as a date value so increment is not possible. ---
**Author:** ![Mariano\_Betta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mariano_betta/32/17895_2.png) [@Mariano\_Betta](https://community.glideapps.com/u/Mariano_Betta)\ **Post date:** [September 22, 2020, 1:11am UTC](https://community.glideapps.com/t/date-time-math/15963/61 "2020-09-22T01:11:36Z")
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 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 22, 2020, 1:28am UTC](https://community.glideapps.com/t/date-time-math/15963/62 "2020-09-22T01:28:42Z")
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. [Previous page](https://community.glideapps.com/t/date-time-math/15963.md?page=2) [Next page](https://community.glideapps.com/t/date-time-math/15963.md?page=4)