UFN_SALESDEPOSITPROCESS_COMPUTEPAYMENTDATE

create function dbo.UFN_SALESDEPOSITPROCESS_COMPUTEPAYMENTDATE (
    @PAYMENTDATEOPTIONCODE tinyint,
    @PAYMENTDATE date
)
returns date
as begin

    if @PAYMENTDATEOPTIONCODE = 2 begin  -- Specific day

        return @PAYMENTDATE;
    end

    declare @TODAY date = dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEWITHTIMEOFFSET(getutcdate(), 1);

    if @PAYMENTDATEOPTIONCODE = 0 begin  -- Today

        return @TODAY;
    end

    return dateadd(day, -1, @TODAY);

end