Calculated column - date to YYQQ

[Mark Hogsett]

Newbie here.  My goal is to create a calculated column, convert a date to YYQQ, where QQ is the quarter displayed as Q1, Q2, Q3, or Q4.  The purpose is to aggregate by year/quarter and allows sorting by this column, group projects, etc.  

Thank you.

[Olivier Keugue Tadaa]

Hi @Mark Hogsett

 

If your date column is named "Date", then the below expression should work

Right(String(Year([Date])),2) & Quarter([Date])

Also note that with a date column, you can use one of these built-in hierarchies on your charts.

[Mark Hogsett]

Awesome, thank you.  I like the visual of the YYQQ date format.  Thanks also for the tip on using the build in hierarchies on charts.  Very helpful.

[Olivier Keugue Tadaa]

Happy to hear it answers your question