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
Solved! Go to 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