AnsweredAssumed Answered

Finding records within a year range

Question asked by RogerWatson on Aug 29, 2013
Latest reply on Aug 31, 2013 by RogerWatson

Title

Finding records within a year range

Post

     I have two tables, one is 'Membership' data (includes a Membership_Year field) and another table named 'Year Range' with just two number fields Start_Year and End_Year.

     I want a script to find records from the Membership table where the year of membership is between two dates (just the year) from the Year Range table.

     For instance, members with a Membership_Year value of 2013 or 2014. Have tried with a table with preset values for the Start_Year and End_Year using global values and with normal values.

Outcomes