# Search Functionality - Date System

**URL:** <https://community.glideapps.com/t/search-functionality-date-system/71216>\
**Category:** Ask for Help\
**Created:** [February 27, 2024, 4:54pm UTC](https://community.glideapps.com/t/search-functionality-date-system/71216 "2024-02-27T16:54:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ben164](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ben164/32/54019_2.png) [@Ben164](https://community.glideapps.com/u/Ben164)\
**Post date:** [February 27, 2024, 4:54pm UTC](https://community.glideapps.com/t/search-functionality-date-system/71216/1 "2024-02-27T16:54:38Z")

</div>

Good afternoon,

I am looking to build a simple search functionality that looks up data between two dates (a from date and to date - example: 1 Jan 24 - 31 Jan 24) - and my glide database will let me know which records are within these two parameters.

I appreciate this topic has probably been answered many times but I cannot see a thread that directly shows how this works.

Any help is appreciated.

Many thanks!  
Ben

---

<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:** [February 27, 2024, 5:11pm UTC](https://community.glideapps.com/t/search-functionality-date-system/71216/2 "2024-02-27T17:11:41Z")

</div>

Capture the two dates in two user specific columns, and then use them in a Query as filters.  
eg:

- Date is on or after This row → Start Date
- Date is on or before This row → End Date

Then use the query as a source of a collection.
