0

I have content query web part for displaying the future events. But the web part is displaying the past events as well. For example, I had two events in March and 3 in April. It shows all five event. I want it to show only April events.

2 Answers 2

2

Look in the web part properties for the filter settings. You can choose a date column and date filter criteria to apply to the content query web part. For example, you can configure a filter on an Announcements list for items created "greater than" today.

See more on standard filters a similar thread on MSDN Forums.

If the field you want is not displayed in the filters list, download the .dwp file and modify it manually to add the field. MSDN has a walkthrough of the specific steps required.

Created and Modified are in the filter list but not some other time and date fields. For example, the start date and end date fields of a calendar list are supported by the content query web part when you manually edit the .dwp and add the fields in as described on MSDN.

8
  • There is no "Time and Date" column in the filter options.
    – Gravity M
    Apr 3, 2013 at 14:34
  • What is your source list? A time and date column in the announcements list for example, is named created.
    – Tom Resing
    Apr 3, 2013 at 19:59
  • My source list is just a calender and we add events to it
    – Gravity M
    Apr 4, 2013 at 16:10
  • Updated my answer for a calendar list. Created and Modified are in the filter list but not some other time and date fields. For example, the start date and end date fields of a calendar list are supported by the content query web part when you manual editing the .dwp and add the fields in as described on MSDN.
    – Tom Resing
    Apr 5, 2013 at 17:21
  • Today is not a valid value for the filter in SP13... Aug 24, 2015 at 11:20
0

When I look into filter option it also shows this example in the explanatory text below the filter: To filter on a column based on the current date or the current user of the site, type [Today] or [Me] as the column value.

3
  • and how would you filter TODAY and the future?
    – Benny Skogberg
    Apr 13, 2018 at 15:23
  • Can you edit the answer to make it more valid?
    – Benny Skogberg
    Apr 16, 2018 at 7:38
  • By using 'greater of equal to'. Apply this filter: "Show only the items when the following is true: --> Show the items when the column" now select your column title with contains dates. Then select "Is greater or equal to" --> type exactly this: [Today]
    – agrior
    Apr 17, 2018 at 20:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.