[ I don't see a date views issue component, please update if this should go somewhere else ]

When you specify a granularity of year, month, day (no time) for a date CCK field, the date is stored in the DB with a Time of 00:00. The date filter only works with full granularity. I think for most the expected behavior when filtering dates >= now is that all events *today* and in the future should be shown. But really the filter is only looking for things greater than or equal to NOW (usually later than 00:00, and your CCK node for *today* has the date of today at 00:00, so it is considered as earlier than NOW.

This really is as you would expect for a definition of "Now". The feature request would be to add an option keyword of "today" in the option box in addition to "now" and when this is the case, use today at 00:00 for the >= query. An alternative is to interpret now as today for fields with lesser granularity (would work for y/m granularity as well).

-P

Comments

blackdog’s picture

blackdog commented

+1 one for this. Would be extremely useful. I started looking into this yesterday, I'll try to get something going for testing this weekend, ,if I can wrap my head around things.

karens’s picture

karens commented
Version: 5.x-2.x-dev » 6.x-2.x-dev

I've added this to the 5.2 version, I'll have to do it differently in 6.2 since the code is completely different there.

karens’s picture

karens commented
Status: Active » Fixed

I've made a number of commits to the filters today. The filter now uses the granularity that you choose for the filter. If you set it to 'day' granularity it will look for any date on the date, regardless of the time. If you used an older version of this module, you may want to delete your existing filter and create a new one, since there are a number of new options you can set.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.

chadchandler’s picture

chadchandler commented
Status: Closed (fixed) » Postponed (maintainer needs more info)

So what are you guys using for nodes greater than, less than, etc. of today? Filter of CCK Date field (day) now? Or CCK Date field (date) today? Fill me in ... the update is confusing. Thanks!

karens’s picture

karens commented
Status: Postponed (maintainer needs more info) » Fixed

Don't reopen an old, closed feature request with a support request. User greater or equal to 'now'.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.

dyke it’s picture

dyke it commented
Status: Closed (fixed) » Active

I think this is actually still an issue. The views date filter works perfectly, but the actual date field doesn't comply.

For example:

If I have an all day event on today, the views filter will show this event since it is set to "greater than or equal to now" with the granularity set to "day". However, the actual date field doesn't appear because it is set to appear "now + 14 days" and all day events default to "12am" and therefore according to the date field it has already past. I need the granularity on the date field to be in "minutes" for events that are not all day. Is there any way around this?

Any thoughts/help is greatly appreciated! :) I'm using drupal 6.14 and date 6.x-2.4.

kars-t’s picture

kars-t commented
Status: Active » Closed (duplicate)

Duplicate of #259308: Allow "fuzzy" granularity