Discussion Forum: Get Start of Financial Year for any given date - HeavenCore | IT Solutions Built on Open Source Software

View Thread

Get Start of Financial Year for any given date
admin	#1 Posted on 25-10-2011 13:40
Posts: 630 Joined: 19/11/2006 00:08	Simple function to get the start date of the financial year of any given date: Code Download source CREATE FUNCTION [dbo].[fn_GetStartOfFinancialYear] ( @DateStr VARCHAR(10) ) RETURNS DATETIME AS BEGIN DECLARE @Date DATETIME SET @Date = CONVERT(DATETIME, @DateStr, 103) RETURN CONVERT(DATETIME, '01/04/' + CONVERT(VARCHAR(4), YEAR(DATEADD(mm,9,@Date)) - 1), 103) END GO Example Usage: Code Download source SELECT dbo.fn_GetStartOfFinancialYear('06/09/2011') ; SELECT dbo.fn_GetStartOfFinancialYear('01/02/2011') ; Jordon Pilling \| Heavencore Administrator
	Web

Jump to Forum