Use SQL to Filter Drupal Views

Answer 1

I found a temporary solution which involves implementing the views_pre_execute hook inside the views module.

I've documented it here in the comment labeled "Use SQL value for filter value on CCK integer field".

I'm not very happy with this solution, though, because it seems a bit of a hack.

Answer 2

You really ought to be using a date field, then you'd have "Now" in all of your filter options.

If Views and CCK know your field is a date, they give you a lot more flexibility in how they filter and display the field.