islanded Posted March 18, 2012 Report Share Posted March 18, 2012 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 Quote Link to comment Share on other sites More sharing options...
0 HongTaiLang Posted March 19, 2012 Report Share Posted March 19, 2012 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 Quote Link to comment Share on other sites More sharing options...
0 NailDyanC Posted August 3, 2019 Report Share Posted August 3, 2019 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/ Quote Link to comment Share on other sites More sharing options...
0 PotatoMato Posted September 28, 2022 Report Share Posted September 28, 2022 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 Quote Link to comment Share on other sites More sharing options...
Question
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
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.