I am trying to write a query that will return data on a quarterly basis.
example, select data from table
where data is between 1st quarter and 2nd quarter.
data could be queried for any month in any quarter.
our company's quarter starts in march.
first quarter is mar - may, second quarter is jun-aug,
third quarter is sept - nov, and third quarter is dec-feb.
can someone please help me out on this?
thanks in advance.
example, select data from table
where data is between 1st quarter and 2nd quarter.
data could be queried for any month in any quarter.
our company's quarter starts in march.
first quarter is mar - may, second quarter is jun-aug,
third quarter is sept - nov, and third quarter is dec-feb.
can someone please help me out on this?
thanks in advance.