# Fun with Dates **URL:** \ **Category:** Project Showcase\ **Created:** [January 24, 2021, 8:25pm UTC](https://community.glideapps.com/t/fun-with-dates/21684 "2021-01-24T20:25:08Z")\ **Posts on this page:** 20\ **Page:** 6
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 20, 2021, 6:18pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/103 "2021-02-20T18:18:10Z")
šŸ¤¦ā€ā™‚ļø šŸ¤£ ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [February 26, 2021, 6:05pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/104 "2021-02-26T18:05:09Z")
> [@Jeff\_Hager](#): > > - 3 days from now When you see all the bugs in D/T column and decide to use this trick šŸ¤Ŗ ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/2/d2a4ca0f295bd31e1c709ee1a02b2659e5550c69.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/9/994faf505c31418c5c3564065c57da6dfd91ebe4.png) Also using` # days from now` colunn to create D/T Start & End columnā€¦ thatā€™s awesome! lol ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/6/b6df101dd9044988f449fab605ca35ac0e3e7d99.png) ---
**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\ **Post date:** [February 28, 2021, 1:36am UTC](https://community.glideapps.com/t/fun-with-dates/21684/105 "2021-02-28T01:36:34Z")
this is very interesting ā€¦! I have a question ā€¦ is there a way to determine the day of the week or 2 weeks ā€¦? Example: if I want a Monday in the next 2 weeks, what should I do ā€¦? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 28, 2021, 5:31pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/106 "2021-02-28T17:31:16Z")
Yeah, thereā€™s probably a few ways to do that. Would it always be two weeks from today or two Mondays? For example, today is Sunday. Two Mondays from today would be March 8th, but the next Monday after two full weeks would be March 15th. Just trying to understand a little better, your use case and what you want to achieve. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [March 10, 2021, 1:59pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/107 "2021-03-10T13:59:58Z")
Itā€™s not about Date, but itā€™s related to Math column and I guess you wizards can help me: How can I turn a number like `$12.561.133.187` into `$12,5 billions`? _PS: In Glide Editor, not GSheets._ ---
**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:** [March 10, 2021, 2:06pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/108 "2021-03-10T14:06:49Z")
![Screen Shot 2021-03-10 at 9.06.39 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/f/cf2b347e436c403925b51c1f77bf6bcf2b02d42c.png) Math column in my case was Votes/1000 ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [March 10, 2021, 2:12pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/109 "2021-03-10T14:12:45Z")
Oh yea! šŸ¤¦ā€ā™‚ļø In my case just did /1000000000 for billions Thanks Bob! ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [March 10, 2021, 3:09pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/110 "2021-03-10T15:09:37Z")
You working out how much you want to earn using glide šŸ˜† ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [March 10, 2021, 3:10pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/111 "2021-03-10T15:10:12Z")
lmao in a near future maybe šŸ¤£ ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [March 10, 2021, 3:14pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/112 "2021-03-10T15:14:25Z")
> [@Rosewebstudio](#): > > You working out how much you want to earn using glide šŸ˜† maybe how much @Robert_Petitto and @eltintero earn nowadays šŸ¤£ ---
**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:** [March 10, 2021, 3:16pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/113 "2021-03-10T15:16:02Z")
pshā€¦NOPE. Maybe @eltintero ā€” heā€™s much more business savvy than I am. ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [March 10, 2021, 3:17pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/114 "2021-03-10T15:17:52Z")
They have the full share of the market with their flashy videos etc (they deserve the success, so do you!) šŸ‘ ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [March 10, 2021, 3:19pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/115 "2021-03-10T15:19:53Z")
Oh, thank you so much! šŸ˜ ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [March 10, 2021, 3:22pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/116 "2021-03-10T15:22:58Z")
**Asset Market šŸ¤«** ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/e/6ea7536783d9383898ed5f80697be88336e7d65e.png) ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [March 10, 2021, 3:24pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/117 "2021-03-10T15:24:21Z")
Ohh lovelyā€¦fun with figures ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [March 10, 2021, 3:26pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/118 "2021-03-10T15:26:17Z")
> [@Rosewebstudio](#): > > fun with figures šŸ¤” sorry lol ---
**Author:** ![Fanny\_Ditomene\_Sekwe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fanny_ditomene_sekwe/32/10112_2.png) [@Fanny\_Ditomene\_Sekwe](https://community.glideapps.com/u/Fanny_Ditomene_Sekwe)\ **Post date:** [March 10, 2021, 7:16pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/119 "2021-03-10T19:16:57Z")
I learned more in a day reading posts on this forum than in 4 (wasted) years in college. Thanks for the tip. God bless šŸ† šŸ„‡ šŸ’° ---
**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:** [March 11, 2021, 11:51pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/120 "2021-03-11T23:51:38Z")
> [@Robert\_Petitto](#): > > Maybe @eltintero ā€” heā€™s much more business savvy than I am. Haha youā€™re excellent as well man, but Jesus is truly business savvy. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [June 2, 2021, 3:30pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/121 "2021-06-02T15:30:28Z")
Figured out a way to get System/GMT time within Glide. > [@clock3 System/GMT Time - Solved!](https://community.glideapps.com/t/system-gmt-time-solved/27524): > > This is an extension of the request for [System Time, please](https://community.glideapps.com/t/system-time-please/26837). Thereā€™s been a lot of questions for a while about how to get a universal time that can be shared for multiple users across multiple time zones. Most of you will know that any time your get a date/time from one of the glide special values, it will always be the userā€™s local time. But if you donā€™t know which time zone they are in, then you have no easy way to convert that date/time into something standard, like Greenwich Mean Time, toā€¦ ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [June 3, 2021, 1:17am UTC](https://community.glideapps.com/t/fun-with-dates/21684/122 "2021-06-03T01:17:13Z")
May have to follow the whole thread below, but I wanted to share something I learned today. If you create a template column with a date/time and any indication of a timezone, then create a math column to convert that template to a date, then it will lock that date/time to that timezone, but show the date/time converted as it would be in the userā€™s local timezone. It has some weird issues sometimes and doesnā€™t seem to allow for all types of date math, but it could solve a lot of peopleā€™s issues with locking a date/time to a specific timezone. > [@clock3 System/GMT Time - Solved!](https://community.glideapps.com/t/system-gmt-time-solved/27524/28): > > Wow, I guess I didnā€™t realize that this would work for other timezones. So essentially, if you append the timezone code, such as PST, PDT, MST, MDT, CST, CDT, EST, EDT, etc. or if you append +0, +5, +8, etc. (not sure about negatives or decimals), or better yet, GMT+5, GMT+8, GMT-5, GMT-8, GMT+12:30, etc. after any date/time, it will lock that date time to that timezone, and whatā€™s displayed to the user will adjust accordingly to the userā€™s local time. This could be a huge advantage for creating meetings or appointments that cross timezones as every user would see a time according to their local timezone. [Previous page](https://community.glideapps.com/t/fun-with-dates/21684.md?page=5) [Next page](https://community.glideapps.com/t/fun-with-dates/21684.md?page=7)