Forum Discussion

kirberry's avatar
kirberry
Frequent Visitor
8 years ago

Expanding Recurring Calendar Events for Dynamic Display

Hi,   I have a SharePoint calendar with recurring events for the next 30 years as a Master Staff Schedule.  I'm looking for a way to find all dates between the Event Date and the End Date and then ...
kirberry's avatar
kirberry
Frequent Visitor
8 years ago

Here is the calendar...for all the names in Title field, I have recurring events that show the Start Date (EventDate) and the End Date.  There is a column that captures the Recurrence as TRUE.  What I'm looking for is a way to expand all the dates between the start and end date so that if I want to create a date picker with today's date, it can show me who is where on this specific date.

 

 

kirberry's avatar
kirberry
Frequent Visitor
8 years ago

Update - I found a way to expand all dates between two dates (easy) and I just found the calendar recurrence data

 

<recurrence><rule><firstDayOfWeek>su</firstDayOfWeek><repeat><weekly mo="TRUE" weekFrequency="1" /></repeat><repeatInstances>100</repeatInstances></rule></recurrence>

 

Now the question is, how can I expand all dates between two dates while applying the recurrence rule?  I don't want all dates, but every Monday between those dates.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I want to retrieve the recurrence items as well, how you manage to expand the dates and where is the calendar recurrence data?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    kirberry 

    Have you managed to find a solution?
    Cheers!
    A