EntityQuery how to get all delta and good for field_dates I've got these dates linked to a node.



I just want to make a request to render all node when time() is between field_date_value AND field_date_end_value OR time() is &lt; to field_date_value

(ps: time() = 06-26)

I coded this for that :



And my render is :



So I think this code find some good value in database but is returning only 1 case with the first date which is wrong instead of the good which is the second and the third.

My wish :



Thanks in advance.
As far as I can see you could already help your self by making your conditions more simple:


  just want to make a request to render all node when time() is between field_date_value AND field_date_end_value OR time() is &lt; to field_date_value


So actually your final condition (which is equivalent with what you wrote is)
time() &lt; field_date_end_value

Also I advice you to use the request time (from Time service) instead of time: in most of the case is that's what should be used.