When exposing a date field with granularity DAY in a user view for user creation date.

SELECT users.uid AS uid, users.created AS users_created, users.name AS users_name, users.mail AS users_mail FROM users users  WHERE DATE_FORMAT(FROM_UNIXTIME(users.created), '%Y-%m-%%d') > '2011-01-20' ORDER BY users_created DESC

I cannot reproduce what the reason for "%%" is in the query. It should be much more %Y-%m-%d.

Comments

schluckreizauf’s picture

schluckreizauf commented

I had the same issue, since I was told, that the preview in views only shows the unprocessed query. If you look at the views result in the frontend, it will use the processed query and show correct results. So this is not a bug, it's only an inconvenience within the preview.

damienmckenna’s picture

damienmckenna
Location TN, USA
commented
Issue summary: View changes
Status: Active » Closed (won't fix)

Unfortunately the Drupal 6 version of the Date module is no longer supported. That said, we appreciate that you took time to work on this issue. Should this request still be relevant for Drupal 7 please feel free to reopen it. Thank you.