UFN_BATCHNUMBERINGSCHEME_DATEFORMATCODE_GETID

/*
Generated by Blackbaud AppFx Platform
Date:  11/30/2010 11:16:30 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.8.2022.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE FUNCTION dbo.UFN_BATCHNUMBERINGSCHEME_DATEFORMATCODE_GETID(@Description nvarchar(10))
RETURNS tinyint WITH EXECUTE AS CALLER
AS
begin

    return case @Description
        when 'MM-DD-YY' then 1
        when 'MM-DD-YYYY' then 2
        when 'MM-YY' then 3
        when 'MM-YYYY' then 4
        when 'DD-MM-YY' then 5
        when 'DD-MM-YYYY' then 6
        when 'MMDDYY' then 7
        when 'MMDDYYYY' then 8
        when 'MMYY' then 9
        when 'MMYYYY' then 10
        when 'DDMMYY' then 11
        when 'DDMMYYYY' then 12
        when 'MM/DD/YY' then 13
        when 'MM/DD/YYYY' then 14
        when 'MM/YY' then 15
        when 'MM/YYYY' then 16
        when 'DD/MM/YY' then 17
        when 'DD/MM/YYYY' then 18
        when 'YY' then 19
        when 'YYYY' then 20
        when 'YYMM' then 21
        when 'YYYYMM' then 22
        when 'YYMMDD' then 23
        when 'YYYYMMDD' then 24
        when 'YYDDMM' then 25
        when 'YYYYDDMM' then 26
        when 'YY-MM' then 27
        when 'YYYY-MM' then 28
        when 'YY-MM-DD' then 29
        when 'YYYY-MM-DD' then 30
        when 'YY-DD-MM' then 31
        when 'YYYY-DD-MM' then 32
        when 'YY/MM' then 33
        when 'YYYY/MM' then 34
        when 'YY/MM/DD' then 35
        when 'YYYY/MM/DD' then 36
        when 'YY/DD/MM' then 37
        when 'YYYY/DD/MM' then 38
        else -1
        end 

end