Please reference this cross post... I think the bug is on datefield and not in Views.
http://drupal.org/node/288078

Under 6.x-2.0-beta3 I have a date cck field. The date format saved in the database is: 2008-10-18T00:00:00
Views using FROM_UNIXTIME() cannot read this as a valid date so it results in the date being: 1969-12-31 which of course makes your view wrong.

As I said in the Views post... this is either a format issue on DateField... or a problem with Views and the FROM_UNIXTIME function incorrectly applies localtime correction.

I would think the easy answer is to have datefield save its format like node does... like this: 1215382015

Thoughts?

Comments

KarenS’s picture

KarenS CreditAttribution: KarenS commented
Status: Active » Fixed

Use the latest -dev code, there have been lots of fixes since the beta3 version.

Anonymous’s picture

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

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