# šŸ†• 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:** 2
**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 17, 2020, 6:59pm UTC](https://community.glideapps.com/t/date-time-math/15963/21 "2020-09-17T18:59:53Z")
Fantastic! working in Glide Sheets! Ive got my first days elapsed since birth calculated: I am only a couple of days old (lol) ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [September 17, 2020, 7:06pm UTC](https://community.glideapps.com/t/date-time-math/15963/22 "2020-09-17T19:06:55Z")
Love that you can format the dates and Now just like the date column! ![Screen_Shot_2020-09-17_at_3_05_49_PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c837b83389b414c26e45c3404addee75b0e3f1be.png) ---
**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 17, 2020, 7:59pm UTC](https://community.glideapps.com/t/date-time-math/15963/23 "2020-09-17T19:59:15Z")
Okay this is as far as I have gotten. Iā€™ll add more comparisons later on. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1b9d8650eebff0aa2decf31a1acdc201ea300af9.jpeg) This is Glide sheet. Not google. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [September 17, 2020, 8:01pm UTC](https://community.glideapps.com/t/date-time-math/15963/24 "2020-09-17T20:01:09Z")
Unpinned on September 17, 2020, 8:01pm UTC ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [September 17, 2020, 8:01pm UTC](https://community.glideapps.com/t/date-time-math/15963/25 "2020-09-17T20:01:14Z")
Pinned globally on September 17, 2020, 8:01pm UTC ---
**Author:** ![Carlos\_DeSilva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos_desilva/32/19965_2.png) [@Carlos\_DeSilva](https://community.glideapps.com/u/Carlos_DeSilva)\ **Post date:** [September 17, 2020, 9:36pm UTC](https://community.glideapps.com/t/date-time-math/15963/26 "2020-09-17T21:36:30Z")
![tenor](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/cb69be46c24ff6e9138187314f5a750fdffd055e.gif) My goodness, you guys are onā€¦aā€¦roll! ---
**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 17, 2020, 9:46pm UTC](https://community.glideapps.com/t/date-time-math/15963/27 "2020-09-17T21:46:24Z")
Great news! & **ONE MORE THINGā€¦** Not only date maths but also SUPPORT FOR INTERNATIONAL FORMATS that Glides get from system client preferences. I used to have two date fields in order to be able to order by dates (USA FORMAT) and at the same time presenting my local format in the app (EU FORMAT) 1. A FIRST TEXT COLUMN with EU format 2. A SECOND based in an array calculated formula in sheets from which I get automatically the USA format and it is configured in Glide as CALENDAR. Now as youā€™ll see in the video below this SECOND field is recognized by Glide automatically as date and show it in my local format and it works perfectly operating with mathā€¦ which is gorgeous šŸ‘‡šŸ¼ [https://filedn.com/lDHC081CgNFL1PQzn1B4S6u/Glide/2020-09-17%2023-06-57.mov](https://filedn.com/lDHC081CgNFL1PQzn1B4S6u/Glide/2020-09-17%2023-06-57.mov) BE AWARE! @mark please take a look at this behavior when I try to convert my original TEXT EU format in DATE. Itā€™s not working properly. As yo can see in the video below it makes some mistakes. Only dates which are not legible as USA FORMAT are ok. This a common classical issue while converting formats which majority of data sheets have fix it. [https://filedn.com/lDHC081CgNFL1PQzn1B4S6u/Glide/2020-09-17%2023-06-57%20(2).mov](https://filedn.com/lDHC081CgNFL1PQzn1B4S6u/Glide/2020-09-17%2023-06-57%20(2).mov) This a great great improvement and a huge step in the right direction which will require some redesign in non USA FORMAT conceived apps. But it worth it! Thanks for the courage and the hard work! ---
**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\ **Post date:** [September 17, 2020, 11:08pm UTC](https://community.glideapps.com/t/date-time-math/15963/28 "2020-09-17T23:08:34Z")
Christmas is early this year šŸŽ„ ---
**Author:** ![kabookie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kabookie/32/10994_2.png) [@kabookie](https://community.glideapps.com/u/kabookie)\ **Post date:** [September 18, 2020, 2:17am UTC](https://community.glideapps.com/t/date-time-math/15963/31 "2020-09-18T02:17:59Z")
This is a great update! Next maybe a countdown timer to go with 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 18, 2020, 2:49am UTC](https://community.glideapps.com/t/date-time-math/15963/32 "2020-09-18T02:49:52Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/eaeb6a2958f120f8f66c0199aa1a22552ce11d64.jpeg) Okay, more date comparisons. As I am working with Glide sheet (not google sheet); I was not able obviously to punch a formula into the sheet. My workaround was to require Wiz to 1. Provide his DOB; and 2. His last birthday. This is the result. If anyone has a calculation to hand that would save us from requiring a person to enter their last Birthday , please share with us. On google sheet itā€™s not a problem, Iā€™ve already tested. Tx. ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [September 18, 2020, 3:46am UTC](https://community.glideapps.com/t/date-time-math/15963/33 "2020-09-18T03:46:41Z")
Oh my, I absolutely love this! ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [September 18, 2020, 4:14am UTC](https://community.glideapps.com/t/date-time-math/15963/34 "2020-09-18T04:14:16Z")
You can create timers, but not with seconds, unfortunately. Glide will have to read NOW every second for that to work, but I think it reads it every 5 seconds for now. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/37f6a860eb2268e344819ea756c0ed2f80522f34.png) ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [September 18, 2020, 4:45am UTC](https://community.glideapps.com/t/date-time-math/15963/35 "2020-09-18T04:45:32Z")
@Markā€¦can I just say how much I love this feature. This coupled with join text and I have a working version of my **Meet with Me** app _without a single Google sheet formula!!!_ Promo coming soon! ---
**Author:** ![Data\_pixel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/data_pixel/32/11818_2.png) [@Data\_pixel](https://community.glideapps.com/u/Data_pixel)\ **Post date:** [September 18, 2020, 10:03am UTC](https://community.glideapps.com/t/date-time-math/15963/36 "2020-09-18T10:03:50Z")
Great, many thanks ā€¦ useful in some of my apps šŸ˜‰ needed to calculate the age of people with GS is now over ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [September 18, 2020, 10:11am UTC](https://community.glideapps.com/t/date-time-math/15963/37 "2020-09-18T10:11:17Z")
Rebuilt the booking app using these features: [https://bookameeting.glideapp.io/](https://bookameeting.glideapp.io/) The goal with this rebuild progressed as follows: - rebuild using date math functions inside Glide - rebuild without bookings logged into Google Sheets - rebuild without Google Sheets Except for the last goal (Glide needs at least one tab in Google Sheets?), I was able to achieve all goals. I am using just one tab in Google Sheets to log user profiles. PS: This app doesnā€™t check for conflicts, but asks users to avoid booking overlapping slots. ---
**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\ **Post date:** [September 18, 2020, 10:22am UTC](https://community.glideapps.com/t/date-time-math/15963/38 "2020-09-18T10:22:48Z")
@Robert_Petitto did you manage to get a button to add / subtract from a date field using the increment action? This isnā€™t working for me. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [September 18, 2020, 10:34am UTC](https://community.glideapps.com/t/date-time-math/15963/39 "2020-09-18T10:34:49Z")
@sardamit Regarding point 3 (ā€œbuild without Google Sheetsā€), I did not test it extensively, but as a quick test I created an app and then deleted the spreadsheet altogether. The app seemed to still be working. Have you tried this by any chance? (Not sure what would happen to ā€œApp : Loginsā€ or if at all relevant here.) ---
**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 18, 2020, 11:15am UTC](https://community.glideapps.com/t/date-time-math/15963/40 "2020-09-18T11:15:43Z")
A query. Is there a way to use the result as an increment in one column per user? Iā€™m not being able to do it. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [September 18, 2020, 2:45pm UTC](https://community.glideapps.com/t/date-time-math/15963/41 "2020-09-18T14:45:19Z")
Yes, you can increment a user-specific column. ---
**Author:** ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)\ **Post date:** [September 18, 2020, 2:48pm UTC](https://community.glideapps.com/t/date-time-math/15963/42 "2020-09-18T14:48:19Z")
Please @Mark are you aware of non USA formats as @darder explains above ?? Thanks !! [Previous page](https://community.glideapps.com/t/date-time-math/15963.md?page=1) [Next page](https://community.glideapps.com/t/date-time-math/15963.md?page=3)