Closed (fixed)
Project:
Date
Version:
6.x-2.2
Component:
Date CCK Field
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
8 Jul 2009 at 16:31 UTC
Updated:
6 Oct 2009 at 17:00 UTC
PHP Version 5.2.3
I have created a content type called "events" and a field for the event date.
I'm trying to create a view that will only show events after the current date.
I believe drupal is using 01/01/09 as the current date no matter what.
My filter looks like this:
Date: Date Content: Date (field_bio_event_date) - value >= now
but the sql statement when updating the view looks like this(excerpt):
...
WHERE (node.type in ('bio_event'))
AND (DATE_FORMAT(STR_TO_DATE(node_data_field_bio_event_date.field_bio_event_date_value, '%Y-%m-%dT%T'), '%Y-%m-%d') >= '2009-01-01')
phpini shows current date correctly.
| Comment | File | Size | Author |
|---|---|---|---|
| filter sql query.jpg | 183.75 KB | dravidian7 | |
| views_filter.jpg | 47.65 KB | dravidian7 |
Comments
Comment #1
dravidian7 commentedComment #2
arlinsandbulte commentedI've heard of this before and I believe it is fixed in the latest release of Date.
Comment #3
dravidian7 commentedi installed the DATE dev version, and it fixed the issue. thanks.