ClarisWorks: Searching for a Range of Dates with Match Records

This information was provided by Claris Corporation on 16 March 1998, and incorporated into Apple Computer's Tech Info Library.
The following formulas for Match Records will find records that fall between two dates, in this example, between the date range 1/1/92 and 12/1/92.

AND ('DateField' >= TextToDate("1/1/92"), 'DateField' <= TextToDate ("12/31/92"))

or you can use the Date function:

AND('DateField'<=Date(1993,1,1),'DateField'>=Date(1991,6,1))
Published Date: Feb 18, 2012