# Unusual Date Rounding?

**URL:** <https://community.glideapps.com/t/unusual-date-rounding/77255>\
**Category:** Ask for Help\
**Created:** [October 22, 2024, 3:12pm UTC](https://community.glideapps.com/t/unusual-date-rounding/77255 "2024-10-22T15:12:53Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![micheal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/micheal/32/80181_2.png) [@micheal](https://community.glideapps.com/u/micheal)\
**Post date:** [October 22, 2024, 3:27pm UTC](https://community.glideapps.com/t/unusual-date-rounding/77255/2 "2024-10-22T15:27:38Z")

</div>

> [@How to change the date format](https://community.glideapps.com/t/how-to-change-the-date-format/77022/4):
>
> 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](https://moment.github.io/luxon/?gspk=cm9iZXJ0cGV0aXR0bzU5NDE&gsxid=CuVsGZry2f8X0J#/formatting?id=table-of-tokens)

---

_[View the full topic](https://community.glideapps.com/t/unusual-date-rounding/77255)._