I'm trying to filter portal records based on two criteria - FROM and TO DATE, and want to display all records BETWEEN these two dates.
I will be using user input from a drop down list to determine the FROM and TO dates and possibly storing them in a separate table to facilitate filtering and allowing the user to change filter values.
Would love some help on the syntax for this. I'm still fairly new to FMP and getting a bit stuck on some of the syntax to use.
All help much appreciated!