SharePoint 2013 – Filter content query web part with calendar start date

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:

 

CQWPCalendar_1

 

There is a very easy solution for this problem! You create a new calculated column for the calendar:

CQWPCalendar_2

 

After you created the column you can select it through the content query web part and, for example, only display events in the future:

CQWPCalendar_3

  2Comments

  1. Jim Harrison   •  

    Warning 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   •     Author

      Thanks Jim! Appreciate the feedback :) Let me know when you found a solution for this. I will update the post when you do.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>