Overlapping dates


Imagine I have a Type “Event” with “start” and “end”, and in my UI I have 2 Date/Time Pickers.

How can I show a text that the expression be like:
Do a search for all dates that overlap with the Date/Time Pickers.

Thanks in advance :slightly_smiling_face: :computer:

When you say search for dates … perhaps you mean a search for events?

If so … then just set the search constraints with date1 > datetime picker1 event value and another date2 < datepicker2 event value. I am using the > or < operators with no logic in this answer. I just wanted to illustrate the point of using date math for what you want to accomplish. Of course, it gets more complicated than what I state considering what exactly you need to accomplish. For date math I suggest you follow much of @keith content and plugins in this forum.

Thanks, @cmarchan. After a lot of thinking the right conditions I think I did it correctly. :grinning: :computer:

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.