For some reason its not possible to select the start date in the content query web part for a calendar event when you are querying the calendar directly:
There is a very easy solution for this problem! You create a new calculated column for the calendar:
After you created the column you can select it through the content query web part and, for example, only display events in the future:
Jasper Oosterveld is a Microsoft MVP and Modern Workplace Consultant from InSpark within the Netherlands. On a daily basis, he works with customers to implement the Modern Workplace with Microsoft 365. Jasper focuses on collaboration, communication, security, adoption and governance. Jasper loves to share is expertise and love for Microsoft products with everyone who is willing to listen.
4 Comments
Jim Harrison
July 24, 2014 at 10:13 pmWarning to others reading this… this will not work for recurring or multi-day events. The calculated column with be the first (or last) date in the series, not the start and end date for the current instance of the recurring event. Have yet to find a solution for this wrinkle.
Jasper Oosterveld
July 25, 2014 at 7:48 amThanks Jim! Appreciate the feedback 🙂 Let me know when you found a solution for this. I will update the post when you do.
Caroline
December 11, 2014 at 2:48 pmIf you are wondering how to set it to be greater than “Today”, since this is not an option as the column will be treated as Text, you can just type [Today] in the textfield.
Alex
May 16, 2017 at 9:40 pmHi, I found a fix for recurring events on a different forum. Here it is:
To correctly deal with recurring events, make sure that your filters are correct; get the “Begin” column from both sides:
Say you want a window from today to 30 days in the future.
Here’s what the filter would look like:
Begin is Less Than Or Equal To [Today]+30
AND
Begin is Greater Than Or Equal To [Today]
Original post: http://gunnarpeipman.com/2007/10/filtering-sharepoint-calendar-by-start-time/