Calculate fiscal year in SQL Server?

Question

How would you calculate the fiscal year from a date field in a view in SQL Server?

Answer 1

When creating your view using TSQL, use the WHERE clause for your table to specify what you want your date range on the view to be.

If this is a view for a SINGLE fiscal year (in this example, fiscal year being March 1st to February 28th, 2013-2014):

CREATE VIEW [yourViewName] AS

SELECT [column1], [column2], [column3]

FROM [yourTable]

WHERE [dateFieldName] >= '3/1/2013'

AND [dateFieldName] <= '2/28/2014'

GO;

You can also use BETWEEN in your WHERE clause instead of logical operators, if you so choose:

WHERE [dateFieldName] BETWEEN '3/1/2013' AND '2/28/2014'