Search Functionality - Date System

Ask for Help
1

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

2

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.

2 Likes