Hi Team,
I am working with a Constellation UI and using the out-of-the-box Date Range filter with the Advanced option enabled.
I noticed an issue when selecting the “Equals” condition for a date field. The filter does not return all records for the selected date. It seems that the system is also considering the time component of the DateTime value during filtering.
However, from an end-user perspective:
-
Users can only select a date (not time) in the UI
-
They expect to see all cases for that selected date, regardless of time
Expected Behavior:
The filter should consider only the date portion and ignore the time part when using “Equals”.
Questions:
-
Is this the expected behavior in Constellation Date filters?
-
What is the recommended approach to ignore the time portion in filtering?
-
Or is there any OOTB configuration available to handle this?
Any guidance or best practices would be appreciated.
Thanks in advance!
If you change the value in the Compare with dropdown from “Date value” to “Relative date” then you should be able to achieve this for the current day.
Edit: and as 
@JayachandraSiddipeta has mentioned you can use date part if you want to select a specific day.
2 Likes
Hello @Eranda_Weerasingha
I am checking the same functionality in 25.1.2 and i see a Date part option in the Compare with dropdown where user can select a specific date of their choice.
This option is available in 24.1 as well.
Hope this helps.
Regards
JC
3 Likes
@Eranda_Weerasingha this is the ‘advanced’ option, it does require more skill/knowledge to use. Solution is above.
However, if users are struggling with this it might be worth returning to the default option. It is easier to use, and you don’t need to put a time, if you select two dates, then it will be from midnight to midnight, so you can still select a single day (with less clicks than advanced)
1 Like
@Marc_Alderman @JayachandraSiddipeta @MarcCheong Thank you all for your valuable answers and suggestions.
1 Like
