How to get the max quarter

[varma8998]

Hi All,

I have a date field which has few dates like 06/30/2019, 03/31/2019....

I want to have the label name as Quarter for example Q1 or Q2....

How to write the label name as per the max Quarter name

[Frank_Hartmann · Accepted solution]

try like this:

'Q' & Ceil(Month(Date#('06/30/2019'))/3)  

or in script:

'Q' & Ceil(Month(YOURDATEFIELD)/3) as Quarters