Confiforms problems with filtering dates

[Gestión]

Hi there experts,

I have a Date Interval picker and I would like to filter using this field, called MyDate. 

If I set in 'FIlter to apply in entries dataset' MyDate.startDate:<=[today] it filters correctly.

If I set MyDate.endDate:>=[today], it filters correctly too.

The problem happens when I put (MyDate.startDate:<=[today]) AND (MyDate.endDate:>=[today]) -> Nothing appears in the dataset

This has worked in the past, but right now something has changed and it no longer works. Confiforms version is 2.18.4

Thanks a lot

[Gestión]

We have solved it doing like this:

(MyDate.startDate:<[today] OR MyDate.startDate:[today]) AND MyDate.endDate:>=[today]

Sorry to say that I think there must be a problem with '<='

[Alex Medved _ConfiForms_]

Hi

Did a very quick test (it's 18:10 here, March 17th, important for the test results to know)

As when you use [today] like that you get the "today's timestamp at midnight"

Therefore the record "Mar 17, 2021 18:04 - Mar 18, 2021 18:09" does not get into the filtered set (2nd table)

What date intervals do you have that dont get into the filtered set?

Alex