create an "upcoming events" view

First of all, if you want to show Event module dates in Views, this is an Event Views issue. I'm pretty sure there is no Views integration for the Event module yet, so if if you want to see Events in a View, you can't until that is done. I'm pretty sure there is already an issue on the Event Views issue queue about when the Event Views will work with Views 2, so you can find and track that issue. See http://drupal.org/project/event_views.

If you want to show Date module dates in a view, the Date module can do this, but there are still a few bugs in the D6 code that I'm working out. If that's what you're trying to do, take a look at the Date issue queue where there are already a couple threads about getting filters working and you can track them. See http://drupal.org/project/date.

Views also has some built in filters for viewing Drupal core dates in a view. So if you want to see those dates (things like the node created or updated dates), then this is a Views issue. But it doesn't sound to me like that's what you're doing, so I'm assuming this is not a Views issue.

oops, cross-posted :)

Oh, thank god I found this post. I was trying the exact same thing today, and there's me thinking I did something wrong. (I've only been working with drupal for 2 weeks now ...)

I also am using a CCK-created content type with a date field. Adding a filter with Views doesn't give any results, when there clearly are. When I look at the SQL query, I suspect it has something todo with the ADD_UNIX_TIME command.

Sorry to re-open the issue, but could you answer the following questions ?

- What versions of CCK/Date do you recommend to have the least problems ?
- How do I actually properly update a module with new nightlies ?
- Could you link me to some bugs which adress this issue ?

Okay, thanks a bunch.