Date Range on my search form

[jerry]

How do I configure my users to be able to search my database based on a date range. For example, I want them to enter a \"from\" date and a \"to\" date.

[napoleonv]

How do I configure my users to be able to search my database based on a date range. For example, I want them to enter a "from" date and a "to" date.

Hi Jerry,

The first thing you need to make sure of is that you have a field with data type Date/Time. Include this field in a search page and add two criteria for it. The first criteria will be "from". The comparison type for these criteria should be "greater than or equal to". The second criteria will be "to". The comparison type for this criteria should be "less than or equal to". The Boolean operator between the two criteria should be set to AND. This will allow your users to search for record by a date range.

[DonaldScott]

Hi Napoleon, where do I "add two criteria for it"?

Donald

[bahar_vm]

Hi Jerry,

Edit your DataPage, click on next and go all the way to the "configure Search Fields" screen, you can see insert button at the bottom of DataPage Elements, just add criteria to your search field, then set the first criteria to "Greater than or Equal" and the second criteria to "Less than or Equal".

Regards,

Bahar M.

[AtayBalunbalunan]

Here is a documentation on how to add a Criteria on a search field: https://howto.caspio.com/datapages/reports/creating-a-report-datapage/

Just scroll to Configuring the Search Form section.

[Barbie]

Hi,

Here's a screenshot on how to achieve your workflow:

 

Hope this helps.

[RuisiHansamu]

This is a standard feature from Caspio, and it helped me a lot: https://howto.caspio.com/tech-tips-and-articles/range-search-finding-data-between-two-numbers-or-dates/