Filter to display only modified content in Views I created a view that displays the number of nodes modified by each user on a specific month.
I check the "modification date". The problem is that I also obtain nodes that have never been modified but have been created on that date.

In the node table, "created" and "changed" fields have the same value when the node is created. How can I only retrieve the nodes that have been modified but not created on a specific month ?

Maybe a way of doing this is to check if node.changed &lt;> node.created, but how can I do that in views ?
Unfortunately impossible to do it in the current UI. 

There are 3 options AFAIK :


try the module views custom conditions
write an alter hook, 
or implement a filter handler, which is definitely going to be slightly more complicated, but probably more fun :)


A repaired :) attempt to do the alter hook (with help from another answer on this great site) and the add_where_expression function :

function main_mm_views_query_alter(&amp;$view, &amp;$query) {
  if($view-&gt;name == 'admin_views_user') {
    $query-&gt;add_where_expression(0,'users.access &lt; users.login');
  }
}


This is the view that comes with the module admin views. there are 2 columns - access and login, both are dates and this seems to work :) you will want to do a dpm($query) first, to see your actual query.