I've added a date argument to a view and set it to use Node: Updated date.

This is the clause I get added to the views query:

 AND ((DATE_FORMAT(FROM_UNIXTIME(node.changed), '%Y-%m-%d\T%H:%i') <= '2009-12-21T23:03' AND DATE_FORMAT(FROM_UNIXTIME(node.changed), '%Y-%m-%d\T%H:%i') >= '2009-12-21T23:03'))

I don't really understand what this is trying to do; moreover, how would one go about getting a range, eg for a view of 'nodes changed in the last month'?

Comments

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.