Filtering entries for the current day
How Do I?
10 years ago
Hello,
I am trying to filter entries from a single channel whose entries’ dates fall in today’s range i.e. 00:00 to 23:59
As per the documentation I have followed at https://ellislab.com/expressionengine/user-guide/channel/channel_entries.html#start-on
My EE code is
{exp:channel:entries channel="news" status="open|featured|promo" category_group="1" orderby="date" sort="desc" start_on="<?php echo $start_time; ?>"}I have entries which are 3 days old and they still show up!
10 years ago
If you enable template debugging and also the profiler, look at what the entries tag receives for start_on=”” and see how that translates to the actual query that is being executed. Also, when building custom entries tags with parameters i tend to specify dynamic=”no”. This prevents EE from doing guesses based on the URI, just in case.
10 years ago
Thanks GDmac for the suggestion.
It worked when I used the following code
{exp:channel:entries
channel="news"
status="open|featured|promo"
category_group="1"
orderby="date"
sort="desc"
start_on="today"
stop_before="{current_time format="%Y-%m-%d %H:%i:%s"}"
}