I want to show yesterday's posts on a block with views. So I added two date filters. They should be:
<today midnight >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 ?