title: Showing what quarter of a financial year a date is in
body: <p>I'm trying to construct a query that will map two columns, one, a date from a table, the second column an alias to show what quarter and financial year the date falls into.</p>
  
  <p>Unfortunately I don't have enough knowledge of SQL to know where to begin. I know that I'd do this with a combination of <code>getdate()</code> and <code>dateadd(MONTH,,)</code> however nothing that I've put together has come close to working.</p>
  
  <p>To further complicate this the financial years in Australia go from 1st July- 30th of June so quarter one of financial year 2012 would start from July 1st 2012.</p>
  
  <p>I can do this without a statement however I'd much rather have it in a statement as it's going to be used in an SSRS report and a C# application and it would make maintenance significantly easier.</p>