Search Functionality - Date System

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!

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

  • 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.