Okay cool, interesting method.
You need a list of months in a table somewhere, eg:
- January
- February
- March
- etc
And then the Month(Date) value to take a Single Value->from Start from that list.
If using that method, you need to adjust the math formula slightly: Month(Date)-1
1 Like
or just use format date MMMM 
1 Like
I entered manually, in different ways… and my method works all the time… Glide math column is the best
then switch column to a date
1 Like
Thanks for all the help on this.
Date and time is so temperamental on sheets as well, as long as there is a fool proof way to achieve the desired results i’m happy no matter what method. Maybe they’ll fix the Format Date Plugin sometime🙏
I still encountered issues with your method Darren. The problem is that glide components still don’t seem to regard the formatted time as date/time so it doesn’t give condition options such as “is on or after today” etc.
I tried Uzo’s method and it all works, and i get the date/time options for components. I’m using both methods for further testing
These screenshots show the difference for the components options.
1 Like
yep, it works great! I’m very impressed with how well… I tried to enter the date in so many different ways as a text… and it figure out! Great job Glide with the math column!
I would recommend that everybody use this technique, for all dates that come from other sources than Glide date picker… even if it looks like everything is ok.
1 Like
Yes, that’s expected because my method converts the date into a number.
Anyway, it sounds like Uzo’s method is going to work best for your use case. That’s the nice thing about Glide - for any given problem there’s often several different ways to approach a solution. And which is best usually depends on the specific use case.
3 Likes