Unusual Date Rounding?

[micheal]

How to change the date format

The column type is Date & Time. The value always includes a time component, regardless of how it was entered or how you choose to display it. That said, you should be able to filter against a user-supplied date by using “is within”. If your filter isn’t working, please show us how you have set it up, and the data.

aside from that another thing to try out is using a format date column (using Luxon) with “T”
or check other formats here luxon - Immutable date wrapper