# 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:** 4
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [January 28, 2021, 2:51pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/63 "2021-01-28T14:51:29Z")
Fair enough you got me there. What I should have said was equal to the same “ambient temperature”. We could all take comfort in knowing no matter where your friends are in the world we all feel -40 c and -40 F the same. ---
**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:** [January 28, 2021, 2:51pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/64 "2021-01-28T14:51:56Z")
😍 😍 😍 ---
**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 28, 2021, 2:52pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/65 "2021-01-28T14:52:59Z")
> [@Eric\_Penn](#): > > We could all take comfort in knowing no matter where your friends are in the world we feel -40 c and -40 F the same. Except for some of us that never happens, and never will (I hope) 😛 ---
**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 28, 2021, 3:32pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/66 "2021-01-28T15:32:52Z")
Probably the best reply, ahahaha ---
**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 28, 2021, 7:26pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/67 "2021-01-28T19:26:49Z")
@Jeff_Hager @ThinhDinh or whoever knows this: Can Math column count how many characters we have in a text/number column? 😟 ---
**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 28, 2021, 7:29pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/68 "2021-01-28T19:29:24Z")
I’ve already requested, but I super needed now > [@Visibility from Max/Min Length in Text Entry](https://community.glideapps.com/t/visibility-from-max-min-length-in-text-entry/16673): > > I’d love to set the visibility according to min or max length in text entry If you agree, please vote point_down ---
**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 28, 2021, 7:32pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/69 "2021-01-28T19:32:18Z")
I don’t know about the Math Column in Glide, but the “=LEN()” function/formula will count the characters in your GSheet. ---
**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 28, 2021, 7:33pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/70 "2021-01-28T19:33:42Z")
Yeah, the point with formulas is the spreadsheet response time ---
**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 28, 2021, 7:34pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/71 "2021-01-28T19:34:54Z")
Yeah I know what you mean…whereas the Math Column would be instant… ---
**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 28, 2021, 7:41pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/72 "2021-01-28T19:41:31Z")
Not easily, but if you’re willing to put in some work, this is the only solution I know of that’s contained within Glide and shows a count in real time (Not in add/edit/form mode). > [@Filter visibility by Character Count!](https://community.glideapps.com/t/filter-visibility-by-character-count/20867/4): > > I think I got something here. Not the cleanest solution, but not too bad either. Just takes a little math. Here you can see that column 11 has two rows with text in it. New Column L has a template with the value of 1 in it. New Column J is a template that replaces every letter (and space if you choose) with the number ‘1’. You shouldn’t need to replace any numbers as they are already numbers, but you will probably have to include every letter of the alphabet along with any symbols you would… ---
**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 28, 2021, 7:53pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/73 "2021-01-28T19:53:10Z")
Damn @Jeff_Hager , you’re the Lord. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/5/758de5885ee75e4b8a99bc171e6ff1666bab94b6.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/c/5c951597a07420f83ef238cef573b2bf1e5438e9.png) ![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/3/0340282970007f39d76b53bb70333c089bd8228f.gif) ---
**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 28, 2021, 7:56pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/74 "2021-01-28T19:56:04Z")
If you are only counting characters on numeric columns, I think you can skip the ‘1’ column and the template column and just do the math directly on the numeric column. ---
**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 28, 2021, 7:58pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/75 "2021-01-28T19:58:33Z")
Actually I’m using both, and it worked perfectly ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/e/0ecfb35b78052bf2452bfb73ca267dd783e3fa09.png) ---
**Author:** ![Buda\_Queobariu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/buda_queobariu/32/5351_2.png) [@Buda\_Queobariu](https://community.glideapps.com/u/Buda_Queobariu)\ **Post date:** [February 5, 2021, 3:41am UTC](https://community.glideapps.com/t/fun-with-dates/21684/76 "2021-02-05T03:41:45Z")
> [@Jeff\_Hager](#): > > > [@](#): > > > > 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. Greetings, I have a problem, I’m trying to add dates, but specifically months. Ex: today (02/05/2021 + 18 months) trying to do it by MATH, but the expressions DATEM or Month are not valid. Can someone help me? Sorry for the writing I’m using google translator … ---
**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 5, 2021, 3:52am UTC](https://community.glideapps.com/t/fun-with-dates/21684/77 "2021-02-05T03:52:07Z")
Here you go. Just use 1.5 years for the number of years, or you can take your number of months and divide by 12. Same thing either way. > [@Glide Editor screen goes blank when using Math Column](https://community.glideapps.com/t/glide-editor-screen-goes-blank-when-using-math-column/19646/15): > > Edit: I have some updates to this formula that I’ve explained in the post below. You’re requirement to back Feb 29th by a day if it’s not a leap year does complicate it a bit, but that’s not a problem. It just makes for a formula that’s much larger. Here is the formula if we were to allow Feb 29th to roll over to Mar 1st. ((Now-DAY(Now)+15)+(Years\*365.25)) - DAY((Now-DAY(Now)+15)+(Years\*365.25)) + DAY(Now) ‎ ‎ ‎ ‎ ‎ To get the leap year date of Feb 29th to back date to Feb … ---
**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:** [February 10, 2021, 2:37pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/78 "2021-02-10T14:37:37Z")
Quick Q - can’t think… 🤔 **Using 'glide tables’** I need to calculate the _day_ from a _date_ so ‘NOW’ = ‘Wednesday’ (in the uk) ---
**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 10, 2021, 3:12pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/79 "2021-02-10T15:12:41Z")
Day(NOW) will give you the day (number) of the week, then plug that into an ITE ---
**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:** [February 10, 2021, 3:36pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/80 "2021-02-10T15:36:22Z")
Used this in a recent app for a client — check it out: ---
**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:** [February 10, 2021, 3:38pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/81 "2021-02-10T15:38:13Z")
@Jeff_Hager perhaps a flaw here? ---
**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 10, 2021, 3:43pm UTC](https://community.glideapps.com/t/fun-with-dates/21684/82 "2021-02-10T15:43:44Z")
Makes sense, I think ‘Now’ is always going to be ‘Now’ 🙂 [Previous page](https://community.glideapps.com/t/fun-with-dates/21684.md?page=3) [Next page](https://community.glideapps.com/t/fun-with-dates/21684.md?page=5)