Search on days between dates

[islanded]

I have one date field in my table. It's "Next_contact_date". I want to create search criteria that allows me to enter a 'date range' as follows:

Beginning date: enter date or pick from calendar

Ending date:enter date or pick from calendar

[HongTaiLang]

You can add a new criterion for range searching. Set the Logical Operator between criteria to "AND". Set the comparison type of criteria1 to "Greater Than or Equal" or "Greater Than" and the comparison type of new criteria to "Less Than or Equal" or "Less Than".

I found this tutorial may help you: http://howto.caspio.com/datapages/creat ... types.html

[NailDyanC]

Here is the updated article on how to compare two date for range searching: https://howto.caspio.com/datapages/reports/search-and-filter-comparison-types/

[PotatoMato]

Hi! Just to update this post, you may also check this article: https://howto.caspio.com/tech-tips-and-articles/common-customizations/range-search-finding-data-between-two-numbers-or-dates/

 

-Potato

[PotatoMato]

Hi! You may check this article regarding date range using criteria: https://howto.caspio.com/datapages/reports/creating-a-report-datapage/