How to pull Month text

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

Step 1. Math column


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

Thank you!

Great idea. Thank you so much.