2 Replies Latest reply on Jan 8, 2016 3:26 PM by nickausaus

    Filter portal records based on FROM and TO date


      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!