Search Between 2 Calculated Dates?

[ScottDube]

I need to search a table where "date_in_stock" is greater than 24 days but less than 84 days.  So far I can't see how to do this.  I see previous 84 days but that leaves me with records within the 0-24 day range that I can't have.

 

Any ideas would be great!

 

Thanks!

[iren]

Hi ScottDube,

 

You can insert new criteria in your Report DataPage to filter the field by two boundaries. For example for a Date field you can have two Criteria, FROM and TO so you can search for records that fall within a specific date range. 

 

Hope it helps.

[NYCREA]

Where are you seeing the options of "From" and "To"?  I don't see any such options.  Granted, I just started playing around with Caspio, but it doesn't seem too straight forward about how to create search criteria between a range.  For example:  if you want to search for records between a minimum and maximum numeric range or date range; how do you achieve this?  and why isn't it front and center in the tutorials?  If the platform has the ability to execute this, I would think its one of its strongest attributes; why wouldn't they want to market that?

[Walter]

Hello NYCREA,

 

I have added new Criteria for the same field on the Search form.

In the article:
http://howto.caspio.com/datapages/reports/creating-a-report-datapage/

The "Configuring the Search Form" chapter explains it in details.

[PotatoMato]

Hi! Just to update, Caspio has added an article to disable past or future dates: https://howto.caspio.com/tech-tips-and-articles/disabling-past-or-future-dates-in-calendar/

[Kronos]

Hi everyone, just to add to this thread:

Comparison Types in Report DataPages

Hope this helps!