Less than or Equal(<=) is not working correctly on date column filter

Hi Developers,   I have a requirement to fetch the most recent dated record based on a date. The parameter date, I am passing it from a dropdown and I am passing only the date so by default the tim...