UFN_VOLUNTEER_SCHEDULEREMINDER

            create function dbo.UFN_VOLUNTEER_SCHEDULEREMINDER(@RANGE int)
            returns @ASSIGNMENTS table 
                (ID uniqueidentifier) with execute as caller
            as begin

                declare @TO datetime
                declare @FROM datetime

                if @RANGE = 1 --this month

                BEGIN
                    select @FROM = dbo.UFN_DATE_THISMONTH_FIRSTDAY(getdate(), 0);
                    select @TO = dbo.UFN_DATE_THISMONTH_LASTDAY(getdate(), 0);
                END

                if @RANGE = 2 --next month

                BEGIN
                    select @FROM = dbo.UFN_DATE_NEXTMONTH_FIRSTDAY(getdate(), 0);
                    select @TO = dbo.UFN_DATE_NEXTMONTH_LASTDAY(getdate(), 0);
                END

                if @RANGE = 3 --this week

                BEGIN
                    select @FROM = dbo.UFN_DATE_THISWEEK_FIRSTDAY(getdate(), 0);
                    select @TO = dbo.UFN_DATE_THISWEEK_LASTDAY(getdate(), 0);
                END

                if @RANGE = 4 --next week

                BEGIN
                    select @FROM = dbo.UFN_DATE_NEXTWEEK_FIRSTDAY(getdate(), 0);
                    select @TO = dbo.UFN_DATE_NEXTWEEK_LASTDAY(getdate(), 0);
                END

                insert into @ASSIGNMENTS(ID)
                    (select ID from dbo.VOLUNTEERASSIGNMENT
                    where DATE between @FROM and @TO)

                return;

            end