Views Version: 7.x-3.0-alpha1

I was trying to create a blog archive view, like blog/yyyy/mm/dd, where blog/2011/03/10 is supposed to display all posts created on 2011, March 10th. However, the page blog/2011/03/10 actually displays all posts created on 2011, March, 11th, one day advanced to the supplied day argument.

How to reproduce the bug:

  1. clean install, enable modules.
  2. create blog content type, generate dummy contents.
  3. create a view:

      * Arguments:
            o Node: Created year
            o Node: Created month
            o Node: Created day
      * Path: blog
      * Filters
            o Node: Published Yes
            o Node: Type = blog

The year, month arguments show correctly, just the day is wrong, always one day prior to the day argument.

Can anyone point me to what went wrong?

  • 1
    This sounds like a datetime issue relating to the timezone setting of the site.
    – lordg
    Mar 13, 2011 at 9:41
  • just update that the latest 7.x-3.0-beta3 fixed this bug.
    – gilzero
    Mar 31, 2011 at 9:26

1 Answer 1


Actually had this bug, but with views 2 on drupal 6, and instead of going forward a day, our view was going backward a day.

Have you tried updating to --dev to see if the issue still exists? I know a lot of patches have been committed since that alpha was released.

  • 1
    It is probably a bug mentioned and patched here: Incorrect timezone handling in views_date_sql_field() drupal.org/node/1091698
    – gilzero
    Mar 31, 2011 at 4:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.