USP_SMARTFIELD_SPONSORSHIPOPPORTUNITYCHILDAGE

CREATE procedure dbo.USP_SMARTFIELD_SPONSORSHIPOPPORTUNITYCHILDAGE
(
    @ASOF datetime = null
)
as
    set nocount on;
        select
            [SPONSORSHIPOPPORTUNITYCHILD].[ID],
            -- #275040.  In BBIS we need to be able to distinguish between a child with no birthdate and one who is less than 1 year old.

            case SUBSTRING([SPONSORSHIPOPPORTUNITYCHILD].[BIRTHDATE],1,4)
            when '0000' then -1
            else dbo.[UFN_AGEFROMFUZZYDATE]([SPONSORSHIPOPPORTUNITYCHILD].[BIRTHDATE], getdate()) 
            end [VALUE]
        from
            dbo.[SPONSORSHIPOPPORTUNITYCHILD]