QuarterStart and QuarterName Help

[prees959]

Hi,  Im using the following to work out which Quarter a date falls in by using :

QuarterName([End Date])  

We need to change this so that instead of the Quarters running from Apr - Mar they run from Mar to Feb so this month (December) falls in Quarter 4 (Dec-Jan-Feb) rather than Q3.

Can anyone advise on this please?

Thanks 

Phil

[Arthur_Fong · Accepted solution]

Try this:

QuarterName(<Date>,0,3)

QuarterStart(<Date>,0,3)

Replace <Date>  with your Date column.