UFN_DATE_LATESTFROMFUZZYDATE

            create function dbo.UFN_DATE_LATESTFROMFUZZYDATE(@FUZZYDATE dbo.UDT_FUZZYDATE) 
            returns datetime
            as begin
                declare @YEAR as nchar(4);
                declare @MONTH as nchar(2);
                declare @DAY as nchar(2);
                set @YEAR = substring(@FUZZYDATE,1,4);
                if @YEAR='0000'
                    return null;
                set @MONTH = substring(@FUZZYDATE,5,2);
                set @DAY = substring(@FUZZYDATE,7,2);
                if @DAY = '00' begin
                    if @MONTH = '00'
                        set @MONTH = '12';
                    set @DAY = dbo.UFN_DAYSINMONTH(@MONTH,@YEAR);
                end
                return convert(datetime, @YEAR + '-' + @MONTH + '-' + @DAY + 'T23:59:59.997');
            end;