The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
You can try using a formula to extract the date portion from your original date field, regardless of the "include time" setting. This way, you'll always have the intended date without rounding.