# Formatting quarters

**URL:** <https://community.amazonquick.com/t/formatting-quarters/37702>\
**Category:** Q&A\
**Tags:** calculations, formatting, Business-Intelligence-Engineer, quick-sight\
**Created:** [October 31, 2024, 3:50pm UTC](https://community.amazonquick.com/t/formatting-quarters/37702 "2024-10-31T15:50:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![aseaman](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aseaman](https://community.amazonquick.com/u/aseaman)\
**Post date:** [October 31, 2024, 3:50pm UTC](https://community.amazonquick.com/t/formatting-quarters/37702/1 "2024-10-31T15:50:09Z")

</div>

How can I format a quarter year as QQ YYYY e.g. Q3 2024? Custom formats returns the quarter number for each Q in the format box so it looks like 33 2024.

Applying toString to my date variable (so that I can concat a ‘Q’ in from of the 3 2024) returns 2024-07-01 00:00:00.000

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/e/2/e28ff480ceeabebd966ea62b8545d768853759b0.png)

month\_start is the root date field in my set  
quarter prior quarter = addDateTime(-1, ‘Q’, truncDate(‘Q’, {month\_start}))  
quarter prior year = addDateTime(-1, ‘YYYY’, truncDate(‘Q’, {month\_start}))

---

<div class="post-metadata">

**Author:** ![aseaman](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aseaman](https://community.amazonquick.com/u/aseaman)\
**Post date:** [October 31, 2024, 7:28pm UTC](https://community.amazonquick.com/t/formatting-quarters/37702/2 "2024-10-31T19:28:36Z")

</div>

My Colleague J.T. Schellenberg suggested adding a backslash \Q  
It worked!

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/1/4/14e9f1442086223d525970885add3d3018b898f7.png)
