Getting the Quarter for a Specific Date

[KamenRider]

Hi

How can get the quarter for this date

2024-01

2024-03

2024-06

Then format this to:

IF first quarter - results should be Q1

    2nd quarter - results should be Q2 

    3rd quarter - results should be Q3

    4th quarter - results should be Q4

Thanks,

Kamen

[KamenRider · Accepted solution]

Hi,

Thanks for those who check my inquiries. Just got an answer from a friend. Sharing the solution

'Q'+tostring(CEIL(Datetimemonth([BEGIN_DATE])/3))

This will result automatically to Q1, Q2, Q3 or Q4 depending on the date given.

Thanks,

Kamen