Quarter

[fanninam]

I am trying to create a field for Quarter.  I only have a field for Year and a field for Month.  There is no date field.  Only a field for Year and a field for Month.  In this scenario, how can I create a field for Quarter?

[sunny_talwar · Accepted solution]

If month is in number format (like 1, 2, 3 etc)... try this

'Q' & Ceil(Month/3) as Quarter
'Q' & Ceil(Month/3) & '-' & Year as QuarterYear

But if Month is text (like Jan, Feb, Mar etc)... try this

'Q' & Ceil(Month(Date#(Month, 'MMM'))/3) as Quarter
'Q' & Ceil(Month(Date#(Month, 'MMM'))/3) & '-' & Year as QuarterYear

[fanninam]

Thank you Sunny!