More condition for date comparison than before and after

[Regnalf]

I wrote in a previous post about the conditions for a date query that I want to use in a looper that only allows the query before and after, but not greater than or less than. I solved the problem with a custom looper:

Condition Date only before and after

I’m using a custom looper for an event list where only the events with current or future dates should be displayed. Condition “Expression datetime”: {{dc:looper:field key=“event_start”}} ‘after’ {{dc:global:date}} Unfortunately, the condition query at the date only offers me before and after! If i use after, it drops also dates with current date!! I need something like >= in the condition query!

But now I have a problem with an API interface. The API reads dates of events and I only want to list today’s and future events. But with this API there is no possibility to send a filter with the request that restricts the date range. Therefore, I can only perform a query on the individual elements to hide older dates.

With my current query, however, I cannot display events with today’s date!

So please, finally add the option “Date Larger Equal” and “Date Smaller Equal”!

Translated with www.DeepL.com/Translator (free version)

[ruenel]

Hello @Regnalf,

Thanks for writing in! You can utilize the Number condition if you want to use greater than or equal to the current Global date.
{{dc:looper:field key="event_start" format="Ymd"}} >= {{dc:global:date format="Ymd"}}

Cheers.

[Regnalf]

Thanks @ruenel,
this is exactly what I have currently done.
But a date comparison operation should also include “is equal to”!

[tristup]

Hi @Regnalf,

Unfortunately, we don’t have that option right now. But I will check with our development team and, if possible, add it as a feature request for future consideration.

Thanks