Date Range Prompt /Filter

[bbeshlian]

Hello,

I cannot get the prompt to work when I want to filter my Datapage by a date range. I want to enter a start date and end date then have the Datapage display the records that in the range. I have tried a couple of tips in the community forum and nothing has seemed to work.

Thanks,

Bill Beshlian

[Vitalikssssss]

Hi Bill,

Have you tried adding criteria to your date field?

This article shows how you can use criteria in order to filter date field by range:

https://howto.caspio.com/faq/reports-datapages/how-to-add-today-to-after-now-or-next-x-days-criteria/

Hope this helps.

 

[bbeshlian]

Hello

I've tried to add the criteria, pass parameters, etc... This article was very helpful when I was either looking ahead "X" days to see who needs to be scheduled for a class or looking back "X" days to see who has expired certifications. I want to input a start and end of a date range then have this data returned.

Thanks,

Bill Beshlian

[BaySunshine]

Hi Bill,

Instead of 'Next X Days' or 'Previous X Days', try 'Greater than' for first criteria and 'Less than' for second criteria. That way you will get all the records within those dates.

Regards,

[bbeshlian]

Vitalikssssss,

Below is how is set everything up. As you can see I get only one prompt for Expiration_Date.

 

 

 

 

Thanks,

Bill Beshlian

[bbeshlian]

I had this question answered during my Expert Session with a Caspio trainer. I was using the wrong Data Selection criteria on the Search Form.

[IamNatoyThatLovesYou]

Hello Everyone, just sharing that Caspio now has a HowTo documentation for this. You may check it out here.

- Natoy