I use the Date/Time filter all the time for displaying events and time-based content. Yet, I still get confused with the wording in the filter. Below are a few translations of the filter options and common scenarios for your (and my) reference:
Key
1 days in the future = tomorrow
1 days in the past = yesterday
0 days in the future/past = today
Scenarios
The "{Date/Time}" label refers to any Date/Time CMS field including custom fields, Created On, Published On, and Updated On.
Remove an event from the calendar once it ends
Element is visible if {Date/Time} is after or equal to 0 days in the past
Show "Today" if the event is today
Element is visible if {Date/Time} is before or equal to 0 days in the past
This filter needs to be added to the text element that displays “Today”, not the collection item.
Show events that occur a week from today
Element is visible if {Date/Time} is before or equal to 1 weeks in the future
Show events that occur next week
Element is visible if {Date/Time} is after or equal to 1 weeks in the future
Show movies that were released last year
Element is visible if {Date/Time} is before or equal to 1 years in the past
If you have questions or suggestions, let me know and I can add them to the list.