Heyjimi Posted March 8, 2016 Report Share Posted March 8, 2016 I cannot get the right criteria to work in my datapage. I want to search records that falls in between two dates a start date and an end date. I tried the "Greater Than or Equal" and "Less Than or Equal" but that does not work. Thanks Quote Link to comment Share on other sites More sharing options...
0 Walter Posted March 8, 2016 Report Share Posted March 8, 2016 Hi Heyjimi, On your Search page, select the field with dates, add New Criteria (the same was as you add Header&Footer elements or HTML Blocks), select "And" option in the "Logical operator between criteria". Now set the "Greater Than or Equal" comparison type for the Criteria 1 and "Less Than or Equal" for the Criteria 2. It should work. Or select "Dropdown" or "Listbox" Form Element and "Range" comparison type, if it works for you. Quote Link to comment Share on other sites More sharing options...
0 Heyjimi Posted March 8, 2016 Author Report Share Posted March 8, 2016 Hi Walter, Thanks that worked! Quote Link to comment Share on other sites More sharing options...
Question
Heyjimi
I cannot get the right criteria to work in my datapage. I want to search records that falls in between two dates a start date and an end date.
I tried the "Greater Than or Equal" and "Less Than or Equal" but that does not work.
Thanks
Link to comment
Share on other sites
2 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.