How to pull Month text

Ask for Help
1

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

2

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:

3

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
4 Likes
4

Thank you!

5

Great idea. Thank you so much.