Wondering if someone wrote a code to read the recurring events details field and count it?
Let's say I have 5 events
entered in 1 week, but 2 of those entered as recurring - the totals for the
week would show as 4 events instead of 5, because the query count number of
events as number of the rows in the table, using the date range specified.
Since 2 of those are recurring - there is 1 row in the SQL table for both
events and it would count it as 1 event instead of 2 events taking place in
that week. Hope it makes sense. Please advise on how to calculate the events
properly, when recurring events exist... The events are also can be of different type and I would need to count it in separate totals. I would like a way to setup the count in a query in SQL and pass date range as parameters, not on load of the scheduler, since I need to use the count in the gridview with the scheduler on the screen, as well as show the count on the reports. Thank you!