Office 365

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

You Might Also Like

3 Comments

  • Reply
    Jim Harrison
    July 24, 2014 at 10:13 pm

    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.

    • Reply
      Jasper Oosterveld
      July 25, 2014 at 7:48 am

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

  • Reply
    Caroline
    December 11, 2014 at 2:48 pm

    If 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.

  • Leave a Reply