# Filtering date only or date and time?

**URL:** <https://community.glideapps.com/t/filtering-date-only-or-date-and-time/73063>\
**Category:** Ask for Help\
**Created:** [May 4, 2024, 7:40am UTC](https://community.glideapps.com/t/filtering-date-only-or-date-and-time/73063 "2024-05-04T07:40:51Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bungchow\_IDEApps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bungchow_ideapps/32/49062_2.png) [@Bungchow\_IDEApps](https://community.glideapps.com/u/Bungchow_IDEApps)\
**Post date:** [May 4, 2024, 7:40am UTC](https://community.glideapps.com/t/filtering-date-only-or-date-and-time/73063/1 "2024-05-04T07:40:51Z")

</div>

Hi gliders…

I’d like to filter and display data by specific starting date-time (awal periode = fil-start) to ending date-time (akhir periode = fil-finish). However, the table displays data by filtering date only, not filtering date and time (ending time should be before 1 May 2024 at 7 am). Does anyone know why and how to solve it?

Thanks in advance.

 ![Screenshot 2024-05-04 142324](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/1/61afa2fe8788ded8629084c160667506036c3c7b.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [May 4, 2024, 7:48am UTC](https://community.glideapps.com/t/filtering-date-only-or-date-and-time/73063/2 "2024-05-04T07:48:49Z")

</div>

Instead of using “on or after/on or before” (which both consider date only), use “after/before”, which also consider time.

---

<div class="post-metadata">

**Author:** ![Bungchow\_IDEApps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bungchow_ideapps/32/49062_2.png) [@Bungchow\_IDEApps](https://community.glideapps.com/u/Bungchow_IDEApps)\
**Post date:** [May 4, 2024, 8:37am UTC](https://community.glideapps.com/t/filtering-date-only-or-date-and-time/73063/3 "2024-05-04T08:37:55Z")

</div>

It works! Thank you @Darren_Murphy 👍 🙏

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [May 11, 2024, 8:38am UTC](https://community.glideapps.com/t/filtering-date-only-or-date-and-time/73063/4 "2024-05-11T08:38:13Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.