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

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 | |
  • There is no "Time and Date" column in the filter options. – Gravity M Apr 3 '13 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 '13 at 19:59
  • My source list is just a calender and we add events to it – Gravity M Apr 4 '13 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 '13 at 17:21
  • Today is not a valid value for the filter in SP13... – Florian Leitgeb Aug 24 '15 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 | |
  • and how would you filter TODAY and the future? – Benny Skogberg Apr 13 '18 at 15:23
  • Can you edit the answer to make it more valid? – Benny Skogberg Apr 16 '18 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 '18 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.