2 Replies Latest reply on Oct 15, 2014 8:55 AM by philmodjunk

    Showing all records with dates within 30 days

    grdg08

      Title

      Showing all records with dates within 30 days

      Post

      I am very new to FileMaker scripting and everything I try from the help sections are returning errors.

      I am working with a course roster list that has course name and the date the roster was created displayed. I would like it to run a script on enter to show only rosters with dates within the last 30 days. We are not using creation dates. 

      I have tried:

      Enter Find Mode []
      Insert Calculated Result [Select; Attendance::Date; Get ( CurrentDate ) - 30 & "..." & Get ( Current Date )]
      Perform Find

      When entering: Get ( CurrentDate ) - 30 & "..." & Get ( Current Date ) I receive an error that it is an invalid get function.

      Basically I am just trying to keep the list of rosters from being 300+

      Any help is greatly appreciated!

       

       

      fmp2.JPG