Date & Time Format Issues

[ToOFa_Apps]

Okay cool, interesting method.

[Darren_Murphy]

@ToOFa_Apps

I did try the math and template method but my Month (Date) shows as a number, how would i get the month to show as text eg. December

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

[Uzo]

or just use format date MMMM

[Uzo]

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

[ToOFa_Apps]

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🙏

[ToOFa_Apps]

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.

[ToOFa_Apps]

Here are some screen shots for the solution.

[Uzo]

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.

[Darren_Murphy]

@ToOFa_Apps

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.

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.