converting calendar date into Fiscal Year
The most flexible way of doing this is to create a Calendar table in your database and populate it. Then you can join in your query to the Calendar table and use any of the columns there that you need.
Here's an article that discusses it and explains how it works.