Issue with Quarter!

[#1]

Hi All,

I am using the below function to retrieve the quarter but my clients financial year starts from april but where us here when i click on Q1 it selects jan - mar. I want that to select apr-jun and so on. Let me know how it can be done!

I know the solution may be to load the quarter using the inline function. I want know some other solution which can solve this problem.

'Q' & Ceil(Month(DATE)/3) as Quarter

Thanks and Regards,

Rikab

[#2 · Accepted solution]

Hi Rikab

If you subtract 3 months from the given date it should work:

'Q' & Ceil(Month(addmonths(DATE,-3))/3) as Quarter

regards
/Fredrik