Search entries by date range --start_on / stop_before

bob1983

2 posts

my goal is to show entries contained in a data range..

i’ve 2 entries made for testing purposes in a channel named prenotazioni.

1 entry—-> title = from 20 to 22
date is set to 2013-06-20 , expire at 2013-06-22

2 entry—-> title = from 23 to 25
date is set to 2013-06-23 , expire at 2013-06-25

my template looks like:

{exp:channel:entries 
   channel="prenotazioni" 
   start_on="2013-06-01 00:00"
   stop_before="2013-29-29 00:00"
   show_future_entries="yes"
   dynamic="no"
}
         found on system:  {title}

{/exp:channel:entries}

result is :
found on system: from 20 to 22
found on system: from 23 to 25

BUT IF MY TEMPLATE IS SET TO :

{exp:channel:entries 
   channel="prenotazioni" 
   start_on="2013-06-21 00:00"
   stop_before="2013-23-29 00:00"
   show_future_entries="yes"
   dynamic="no"
}
         found on system:  {title}

{/exp:channel:entries}

i will get :
found on system: from 23 to 25

my goal is to find the first entry because is start to 20/06/2013 and expire at 22/06/2013
why i cant retrieve this entry if i set 21 as start_on date??

ANY HELP WILL BE VERY VERY APPRECIATE!!
many thanks

Thread

bob1983

Username

Password

Thread