# Transform a date into a Month/Quarter/Year format

**URL:** <https://community.glideapps.com/t/transform-a-date-into-a-month-quarter-year-format/61538>\
**Category:** Ask for Help\
**Created:** [May 9, 2023, 4:44pm UTC](https://community.glideapps.com/t/transform-a-date-into-a-month-quarter-year-format/61538 "2023-05-09T16:44:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\
**Post date:** [May 9, 2023, 4:44pm UTC](https://community.glideapps.com/t/transform-a-date-into-a-month-quarter-year-format/61538/1 "2023-05-09T16:44:20Z")

</div>

@Robert_Petitto @Jeff_Hager @Darren_Murphy - I swear one of you did a video/write-up on how to transform a date into a reporting column.

In my case I want to transform a date such 5/9/2023 into: Month-May Quarter-Q2 Year-2023

I can then report on all things in ‘May’; all things in ‘Q2’ etc.

I currently create a table which I ‘look-up’ against but I would like to calculate this rather than use the table.

Thanks for all pointers

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [May 9, 2023, 4:56pm UTC](https://community.glideapps.com/t/transform-a-date-into-a-month-quarter-year-format/61538/2 "2023-05-09T16:56:24Z")

</div>

Use date math.

- For Year, it’s just `Year(Date)`
- To get the Month name, I use a lookup table. One column with 12 rows that contain the month names. Then I get the Month Index using `Month(Date)-1`, and then use that in a Single value column taking Month Index from start of my lookup column.
- To get the quarter, use the Month Index value in an if-then-else column:  
– If Index is greater than 8, then Q4  
– If Index is greater than 5, then Q3  
– If Index is greater than 2, then Q2  
– Else Q1

Others might tell you to use the Format Date plugin, and that’s fine. But I don’t trust that, so I don’t recommend it.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [May 9, 2023, 5:33pm UTC](https://community.glideapps.com/t/transform-a-date-into-a-month-quarter-year-format/61538/3 "2023-05-09T17:33:19Z")

</div>

You can probably use a formula to get the quarter (assuming quarters start on the 1st of every month).

`ceiling(month(date)/3)`