What filter type must have a time associated with it or defaults to 12 AM?

A date filter is designed to handle specific dates and times, making it essential for it to have an associated time to perform effectively. When a date filter is used in a query, it often requires both the date and the time component to accurately retrieve the relevant data. If no specific time is provided, the filter defaults to 12 AM, which signifies the start of the day. This is particularly important in data management and reporting scenarios, where time-sensitive data needs to be accurately filtered and displayed.

In comparison, numeric filters primarily work with numbers and do not require a time component to function. Text filters focus on string values and also do not involve time. Boolean filters handle true/false conditions without the relevance of time. Therefore, the date filter's specific requirement for a time value distinguishes it from the other filter types.