Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Confiforms problems with filtering dates

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

2 answers

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 '<='


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

Screenshot 2021-03-17 at 18.16.14.png

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?


Suggest an answer

Log in or Sign up to answer

Atlassian Community Events