How do I filter on dates relative to now in a view?
I'm using Drupal 6.14, Views 6.x-2.7, CCK 6.x-2.6.
I've created a simple content type called Event (based on node). I've added one CCK field to it (of type datestamp) called "Event Date". This is working well. I can create and display events and their start date/time (and optional end date/time) display correctly.
I've also created a view, with the objective of being able to display a block called "coming events". It should display only those events whose start date is in the future, ie. after "now".
The Fields for my view are "Node: Title" and "Content: Event - From date". The Sort criteria is "Content: Event - From date asc". The filters are: "Note: Type = Event" and "Note: Published = Yes". This also works well, ie. the block displays all my created events in the right order.
The final step I need is to filter the Events such that only those events with a "Event - From date" in the future are shown. I did manage this with Views 1 - it was easy to compare this date to "now -600". But with Views 2, I can't figure out how to do this. The closest I've been able to get, after much trial and error, is "Events - From date >= 2009-11-07", ie. hard-coding today's date. But this won't work in general.
Can anyone explain how to achieve what I want? (Detailed step-by-step if possible.)

Possible Solution
Typical! I found this on StackoverFlow a few minutes after I submitted my question:
http://stackoverflow.com/questions/1445406/drupal-6-how-do-i-only-call-u...
What do people think? Is the answer at the link the best way to do it?
(It's working for me: I'm filtering on "now -600" and "now +2 years")
Date Argument.
I would just use a date argument and then a date filter to filter out anything > today. You could even expose the filter to allow people to look forward or backwards.