Views date filter yesterday I want to show yesterday's posts on a block with views. So I added two date filters. They should be:

&lt;today midnight

&gt;yesterday midnight


(-1 day is not ok for me because it spans exactly 24 hours back)

According to the manual: http://php.net/manual/en/datetime.formats.relative.php
I added the two filters as:
Less than "today" (I also tried less than "midnight" or "today 00:00")
Greater than "yesterday" (I also tried greater than "yesterday 00:00")

But they are all showing the items from yesterday and today together.

Is there a way to show items from yesterday 00:00 to yesterday 23:59 ?
I ended up using contextual filter instead of filters. I added:

Content: Created date

Provide default value - php code

return date("d", strtotime("-1 day"));