Filter portal records based on FROM and TO date

Discussion created by nickausaus on Jan 8, 2016
Latest reply on Jan 8, 2016 by nickausaus

Hi all

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!