How to pull Month text

How do you pull the month out of a date value in Glide Tables?

Step 1. Math column

Month(Date)

Replace “Date” with your column containing the date.

Step 2. ITE column to replace the numbers representing the month to text.

I am but a mere mortal but that’s how I’d do it :sunglasses:

An alternative to step 2:

  • Create a Basic text column, and fill it with your month names, eg:
    • January
    • February
    • March
    • etc…
  • Then create a single value column pointing at that basic column, using n from start, where n is the output of your math column at step 1
3 Likes

Thank you!

Great idea. Thank you so much.