There seems to be a problem with the recurrence engine in the supplied DLL, it will not return occurrences for some of the more unusual recurrence rules. Our users often have rules that may relate to an event that happens every 18 or 24 months, so the rule may look something like this:
I created an additional function to return just the next occurrence date after the date specified as follows:
recurrenceRule, DateTime sDate)
DateTime returnVal =
DateTime(2000, 1, 1);
(occStart > sDate)
returnVal = occStart;
When I run the above rule in my web application with an sDate of 9/1/2011...the returned next occurrence date is 9/1/2013 which is the expected result, however when I run the function in SQL as follows:
The result returned is 1/1/2000 (the default return value), which is obviously not correct.
As far as I can see, the only difference here is the version of the recurrence engine. The one created for the CLR function was created in 2008 and the one in my web app is the latest Telerik.Web.UI.dll.
Unfortunately one cannot import the whole Telerik.Web.UI.dll without it importing a whole bunch of .NET dll's also, so is it possible to get and updated version of the Telerik.Web.UI.RecurrenceEngine.dll that was built for this project?