Here is a simplified version of the select statement in the stored procedure EventsGetByRange. This is the SP that the monthly calendar uses.

SELECT * FROM Events
WHERE ((EventDateBegin BETWEEN @BeginDate AND @EndDate) AND (Events.ModuleID = @ModuleID))
     OR
    ((EventDateEnd >= @BeginDate) AND (Events.ModuleID = @ModuleID))

In other words the select statement is grabbing every event that ends after @BeginDate. But that set of events already includes all the events that begin between @BeginDate and @EndDate.

Assuming that the EventDateEnd is always after the EventDateBegin the first half of the WHERE statement can be eliminated. Can someone see a flaw in my logic?

This casts a really wide net for catching the events, but I don't see a way around this unless we split up the recurring events.

Questions and Comments Welcome.

Dan

At first glance I don't see the problem with your logic. 

 

Please log it in Gemini so it doesn't get lost and I will try to confirm that there are no issues and update the sproc accordingly for the next version.

---

Jeremy White
DNN Core Team Alumni

Just FYI, I have make the above change to my Stored Procedure and it works well so far.

I have not used "Gemini" (support.dotnetnuke.com) before, do I need a separate Gemini login account? After I login I assume I would then add my suggestion as a potential "Enhancement" in the "Module:Events" area. Correct?

Thanks

Dan