By xsean on

Hi to all,

Currently i'm facing this problem and let me explain this for more details:

List of Event: d/m/Y format
Event 1 16/01/2010 - 26/01/2010
Event 2 23/01/2010 - 25/01/2010
Event 3 31/01/2010 - 03/02/2010
Event 4 29/01/2010 - 01/02/2010
Event 5 27/01/2010 - 27/01/2010
Event 6 26/01/2010 - 29/01/2010
Event 7 24/01/2010 - 01/02/2010
Event 8 01/02/2010 - 03/02/2010
Event 9 23/01/2010 - 24/01/2010

First day of the week is Monday and last day of the week is Sunday. Let say today is 29/01/2010 and so this week range is 25/01/2010 - 31/01/2010.

May i know how to filter this week event in views using cck date?

The result will be list out is Event 1 to Event 7. Event 8 and Event 9 will not list out because the event date range is not between this week range.

Very appreciate if anyone can share your advise as i tried many ways to filter and still cannot get the result i want.

Thank you.

⋅ Categories: Drupal 6.x

Comments

lauri’s picture

lauri commented

Hello,

I was able to solve this by adding two date filters to my view.

1) From the Add filters list select the "Date: Date (node)" option
2) Selected the date field you want to use for filtering
3) Use Method "AND" for handling multiple date fields
4) Operator "Is between"
5) Date default "now"
6) To date default "now + 7 days"

1) From the Add filters list select the "Date: Date (node)" option
2) Add filter Date: Date (node)
3) Selected the same date field and use method "AND" as well
4) Operator "Is less than"
5) Date default "next monday"

lauri’s picture

lauri commented

Ah, now I noticed that this of course does not include current weeks past events (so the first filter is actually unnecessary)