UFN_EVENT_OCCURSTODAY

Returns whether or not the event occurs on today's date.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_EVENT_OCCURSTODAY
        (
            @ID uniqueidentifier
        )
        returns bit
        with execute as caller
        as 
        begin
            declare @OCCURSTODAY bit = 0

            declare @CURRENTDATE datetime
            set @CURRENTDATE = dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEFROMUTC(getutcdate())
            set @CURRENTDATE = dbo.UFN_DATE_GETEARLIESTTIME(@CURRENTDATE);

            declare @STARTDATE datetime
            declare @ENDDATE datetime

            select
                @STARTDATE =  dbo.UFN_DATE_GETEARLIESTTIME(STARTDATETIMEWITHOFFSET),
                @ENDDATE = dbo.UFN_DATE_GETEARLIESTTIME(ENDDATETIMEWITHOFFSET)
            from dbo.EVENT
            where ID = @ID

            if @CURRENTDATE = @STARTDATE or @CURRENTDATE = @ENDDATE
                set @OCCURSTODAY = 1

            return @OCCURSTODAY
        end