For testing, I've set up a CCK type that has an ISO date field, a datestamp field and the event start/end dates, each with identical dates values for 9 example nodes with 5 dates in March and 4 in April 2006. I have all fields set to use the site's timezone and I'm using US/Eastern everywhere.

I created 3 calendar views, one for each of the 3 types of dates, for testing.

The view that uses the Event start date correctly lists
* March (5)
* April (4)
and includes the events in the correct places on the calendars. However, the views corresponding to each of the CCK date types incorrectly list
* March (4)
* April (5).
It seems that the event on March 31st at 7:00pm (2006-04-01T00:00:00 in the database) is being counted as an April event. That event also does not appear on either the March or April calendar display.

Comments

RayZ’s picture

RayZ commented

I also noticed that dates that *do* appear fine on my calendar appear on the wrong day (next day) if the time is 7pm or later. It looks like it may be using the GMT date to determine where to place it rather than the timezone corrected date.

Anyone else seeing this problem?

RayZ’s picture

RayZ commented

In digging into the code, it looks like the function event_views_handler_arg_type() is not doing any time zone adjustment on the fields it queries. So event_views will not work correctly for CCK date fields that are using time zone adjustments.

I think I'm in a bit over my head in terms of trying to fix it, so my plan is to convert my fields to not do any time zone adjustment and then write a script to update my data.

karens’s picture

karens commented
Status: Active » Fixed

I've removed the calendar functions from the latest Event Views modules (both cvs and 4.7). Use the http://www.drupal.org/project/calendar module for those features now, since that module makes them available with no dependency on the Event module. I just created a 4.7 branch for the Calendar module, but it won't be available as a download until the next time the downloads are updated.

Anonymous’s picture

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