from/to date CCK views filter

Took me some time to figure this one out.

I needed to filter nodes with a from-to date field where 'now' is between the from-to interval. The view should show only nodes that should be published during a certain time frame.

Essentially, you still need to seperate view filters to make this one work. Trying this with one filter didn't work for me.

Before you start: Make sure your content type has a CCK date field has a 'datestamp' type with from/to subfields

Make a filter for the the From field:

1. Add a new filter for the date:date field. You need to select date:date (node).
2. Check the content:YOURFIELD - from date box.
3. Method should be set to AND
4. Now you can configure the newly created filter. Operator should be 'less then or equal to' and set the value in the 'date default' (under relative date) to 'now' (without quotes)

Now make a new filter for the To field

1. Add a new filter for the date:date field. You need to select date:date (node).
2. Check the content:YOURFIELD - to date box.
3. Method should be set to AND
4. Now you can configure the newly created filter. Operator should be 'Is greater then or equal to' and set the value in the 'date default' (under relative date) to 'now' (without quotes)

Save your query and run it through 'preview'. Should work now.

If you'd check the SQL query this combination of filters generate, you should see something along the lines of
... WHERE field_pub_value <= NOW() AND field_pub_value2 >= NOW() ...

Of course, this would be much cleaner if the WHERE clause would use the ... BETWEEN X AND Y ... statement instead.

Why is it that the 'datestamp' type is required?

subscribe

Thanks netsensei! I spent hours trying to figure how to do this -- I kept selecting Content as a filter instead of Date:Date.

Yep a winner for me. Thanks for posting :)