# 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:** 1
**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:** [January 24, 2021, 8:25pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/1 "2021-01-24T20:25:08Z")
I just remembered something from a long time ago. I don’t remember if I had posted about it in this forum or in the old spectrum forum. Can’t find the post in either forum right now. Working on these posts re-triggered this memory. > [@Find the last day of the following month](https://community.glideapps.com/t/find-the-last-day-of-the-following-month/21557): > > I was wondering if it is possible, directly in Glide (without using sheet), to calculate the last calendar day of the month following the current one. For example: today is January 22, the date I need is February 28, 2021. This is useful for some payment installments in commercial contracts. Thanks > [@Glide Editor screen goes blank when using Math Column](https://community.glideapps.com/t/glide-editor-screen-goes-blank-when-using-math-column/19646): > > I am trying to add Math Column for date calculation but as soon as select the columns, the screen goes blank. This happened with me four times. Am I doing something wrong? What I had discovered back then is how ridiculously forgiving the calendar layout is. It can take dates in a variety of formats and still determine the correct date to show. But the really cool thing I had discovered is that you can feed it certain types of text and it will figure out the correct date. I just realized you can do the same thing with a date column. For example, type the following in a date column and it will convert it to the correct date: - tomorrow - yesterday - 3 days ago - 3 days from now - 3 years - 3 years ago - next week - last week - next month - last month - monday (nearest date) - august (nearest date) - etc. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/6/e6f8900e9b0925ab5b11307ab2052d3ab6446324.png) converts to ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/d/7d694828b3fbe5901f658cc62ce8491403373331.png) You get the idea. It’s awesome because if you type in that text, it will do the math for you and return the correct date. The only downside is that it only seems to do the math from today, so I’m not sure how to do the same thing with different dates other than today. I’ve known for a long time that this was possible with the calendar layout, but I didn’t put two-and-two together until now that it will also work with a date column. This might be useful for some kind of recurring events or some other logic. I’d be curious if anybody else discovers some other text that works or some other use cases. It appears that it converts the text to a static date, so it will not continually roll as the date and time changes. Could be useful in a form where you just want to write a date two weeks from now without making a user select a date in a calendar or doing some backend date math to figure it out. Might save on a couple of computed columns. Maybe the Glide team could shed some light on all the possible combinations of text that can be converted into a calculated date. ---
**Author:** ![ehdubya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ehdubya/32/24087_2.png) [@ehdubya](https://community.glideapps.com/u/ehdubya)\ **Post date:** [January 24, 2021, 8:33pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/2 "2021-01-24T20:33:36Z")
WOW…had no idea! This makes SO much sense now though! Thanks Jeff! I wonder if EOD would work…or how to figure that out…hmm 🤔 ---
**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:** [January 24, 2021, 10:39pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/3 "2021-01-24T22:39:05Z")
Wow this is absolutely incredible. ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [January 25, 2021, 4:56am UTC](https://community.glideapps.com/t/fun-with-dates/21684/4 "2021-01-25T04:56:55Z")
This is great. Did not know about it Even if we are typing just “2 years”, it shows date after 2 years from now. This is amazing. ---
**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:** [January 25, 2021, 5:01am UTC](https://community.glideapps.com/t/fun-with-dates/21684/5 "2021-01-25T05:01:26Z")
HOLY COW. [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/4/24df029017f1ef4aae949957f52414cad97df091.gif) ](https://media.tenor.com/images/3a29726ff95ca4e667c8ec0ae83689ff/tenor.gif) Playing with this for the rest of the day…wonder what would happen if you said “Next Month” on January 30…would it say Feb 28 or Mar. 2? or neither? EDIT: - Minutes and hours work too. - 3 minutes ago - 10 min from now - Month Abbreviations work (“Mar” = March 1) - Week Abbreviations work (“Next Fri”) - “This Morning” = 6am today - “This Afternoon” = 3pm today - “Tonight” = 10pm tonight - “Next Tuesday at 9AM” - “Feb 35” = ~~3/7/2021~~ Mar 7, 2021 🤣 - Works nicely in Set Value/Add Row Actions…though it didn’t capture the time… - ![Screen Shot 2021-01-25 at 12.48.42 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/2/027bee3cbe68f6d504a2b1e15ab4883224d352f9.png) - ![Screen Shot 2021-01-25 at 12.48.58 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/d/bd2e215949495f8046cd94aa4c6cfb0da04b4bf1.png) ---
**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:** [January 25, 2021, 5:35am UTC](https://community.glideapps.com/t/fun-with-dates/21684/6 "2021-01-25T05:35:58Z")
> [@Robert\_Petitto](#): > > “Feb 35” = 3/7/2021 Looks like you found a bug, that should be 7/3/2021 😛 ---
**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:** [January 25, 2021, 5:36am UTC](https://community.glideapps.com/t/fun-with-dates/21684/7 "2021-01-25T05:36:36Z")
Silly me and my American bias 🙂 ---
**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:** [January 25, 2021, 5:39am UTC](https://community.glideapps.com/t/fun-with-dates/21684/8 "2021-01-25T05:39:08Z")
hehe, actually I don’t like either. Whichever way you go, it’s going to confuse one group of people. I always use yyyy-mm-dd Apart from being easier to read, it has the added benefit of sorting naturally as a string. ---
**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:** [January 25, 2021, 2:45pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/9 "2021-01-25T14:45:54Z")
Guys, what’s the best way to get weekdays names like _Monday_, _Tuesdays_, _Wednesday_, etc? ---
**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:** [January 25, 2021, 2:57pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/10 "2021-01-25T14:57:08Z")
Most straightforward way is to derive the weekday from the date using a math column, and then an ITE: if weekday is 1 then Sunday etc. I learned this the hard way a few weeks ago, I assumed 1 was a Monday but it was a Sunday haha. ---
**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:** [January 25, 2021, 3:02pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/11 "2021-01-25T15:02:51Z")
> [@Lucas\_Pires](#): > > Guys, what’s the best way to get weekdays names like _Monday_ , _Tuesdays_ , _Wednesday_ , etc? I usually ask my 3 year old son, he knows them all by heart 😂 ---
**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:** [January 25, 2021, 3:05pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/12 "2021-01-25T15:05:49Z")
True! Thanks @ThinhDinh ---
**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:** [January 25, 2021, 3:09pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/13 "2021-01-25T15:09:45Z")
> [@ThinhDinh](#): > > Most straightforward way is to derive the weekday from the date using a math column, and then an ITE: if weekday is 1 then Sunday etc. > > I learned this the hard way a few weeks ago, I assumed 1 was a Monday but it was a Sunday haha. This is exactly what I do. ---
**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\ **Post date:** [January 27, 2021, 1:37pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/14 "2021-01-27T13:37:26Z")
Americans against the world, you do everything differently!😂 I’m moving to Atlanta next year, I’m gonna have such a hard time with dates and temperatures ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [January 27, 2021, 2:26pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/15 "2021-01-27T14:26:21Z")
@PabloMFalero Welcome to the club. I’m still trying to understand temps. ---
**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:** [January 27, 2021, 2:49pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/16 "2021-01-27T14:49:01Z")
Here’s all you need to know… 72= perfect 32= freezing ---
**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:** [January 27, 2021, 2:55pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/17 "2021-01-27T14:55:46Z")
I _really_ want to respond with something clever, but I won’t… 😁 ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [January 27, 2021, 3:18pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/18 "2021-01-27T15:18:00Z")
@Robert_Petitto Hahah!!! ---
**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:** [January 27, 2021, 3:29pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/19 "2021-01-27T15:29:55Z")
72 is perfect, but 32 isn’t freezing…that beautiful weather and quite comfortable to be outside and go for a walk. When it’s -20 (not factoring in wind chill), and the grease around the steering wheel becomes stiff, the foam in the seats become rock hard, and after a 20 minute warm-up and a 15 minute drive, the car vents are still only blowing luke warm air, then you know it’s freezing and you have to put on a jacket. You see, us americans need our own temperature scale because we can live anywhere from a -40 degree frozen hell to a 110 degree burning hell and everything in between. We need bigger numbers so it’s easier to brag to others that we are tougher than everybody else. However, telling people you are going 100kph is way cooler than saying you’re going 60mph, so we screwed up there. ---
**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:** [January 27, 2021, 3:37pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/20 "2021-01-27T15:37:35Z")
> [@Jeff\_Hager](#): > > 72 is perfect, but 32 isn’t freezing…that beautiful weather and quite comfortable to be outside and go for a walk. When it’s -20 (not factoring in wind chill), and the grease around the steering wheel becomes stiff, the foam in the seats become rock hard, and after a 20 minute warm-up and a 15 minute drive, the car vents are still only blowing luke warm air, then you know it’s freezing and you have to put on a jacket. I have no idea what you’re talking about 🤣 ![WhatsApp Image 2021-01-27 at 23.36.21](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/4/24ee273f3bd422c99a09ca6a5f970f36c6119bf5.jpeg) [Next page](https://community.glideapps.com/t/fun-with-dates/21684.md?page=2)