Hi All,

I donno how the UDF code was missed while publishing, I update the code as a new article, however I'm providing the same here also..

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Fn_FinMonth]') and xtype in (N'FN', N'IF', N'TF'))

drop function [dbo].[Fn_FinMonth]

go

Create Function dbo.Fn_FinMonth(@MonthCode varchar(2))

Returns Varchar(2)

As

/*------------------------------------------------------------------------------------------------------------------------------------------

** SQLVersion : SQL 2000

** Function: Fn_FinMonth

** Author : Kartik M

** DateTime: 29 January 2011 22:30

** Version: 1.2

** Purpose: To get the financial month from the respective calander month

** ToCheck:

** Changes: KM - 06 Feburary 2011 - Change the return type form Numeric to Varchar and add Leading Zeros to avoid problem while sorting

------------------------------------------------------------------------------------------------------------------------------------------*/

/*

-- Start of Debugging Stuff

Declare @MonthCode varchar(2)

Set @MonthCode = '02' -- Pass the Month Number as Input

-- End of Debugging Stuff

*/

Begin

Declare @FinMonthC Varchar(2)

Declare @IMonthCode int

Set @IMonthCode = cast(@MonthCode as int)

if @ImonthCode between 4 and 12

Begin

Set @FinMonthC = @IMonthCode-3

Set @FinMonthC = Replicate('0', 2-len(@FinMonthC))+@FinMonthC

End

Else if @ImonthCode between 1 and 3

Begin

Set @FinMonthC = @IMonthCode+9

Set @FinMonthC = Replicate('0', 2-len(@FinMonthC))+@FinMonthC

End

Return @FinMonthC

End

--Select dbo.Fn_FinMonth ('05')

go