Filtering comment by date range in Views I have created a view to filter comments by date range. For date range i am using between operator.


View type : Comment 
Date : comment created (default field)


Issue : When i am trying to filter comment from 2015-11-01 to 2015-11-15

i am getting result from 2015-11-01 to 2015-11-14 only.

what i am missing ? may be some help me ?
Views uses in between operator i.e. BETWEEN min AND max expression. 



This is equivalent to the expression (min &lt;= expr AND expr &lt;= max). Now the query that views create for date is:

(comment.created BETWEEN 1446336000 AND 1447545600)

Search for unix time value of 1447545600

The problem is with the date 2015-11-15, this is treated as 2015-11-15 00:00:00. So 2015-11-15 11:12:13 won't be included. Hope you get my point.