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.

Improve this question

2 Answers 2

Reset to default
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.

Improve this answer
8
  • There is no "Time and Date" column in the filter options.
    – Gravity M
    Commented 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
    Commented Apr 3, 2013 at 19:59
  • My source list is just a calender and we add events to it
    – Gravity M
    Commented 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
    Commented Apr 5, 2013 at 17:21
  • Today is not a valid value for the filter in SP13...
    – Florian Leitgeb
    Commented 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.

Improve this answer
3
  • and how would you filter TODAY and the future?
    – Benny Skogberg ♦
    Commented Apr 13, 2018 at 15:23
  • Can you edit the answer to make it more valid?
    – Benny Skogberg ♦
    Commented 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
    Commented Apr 17, 2018 at 20:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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