AnsweredAssumed Answered

Showing all records with dates within 30 days

Question asked by grdg08 on Oct 14, 2014
Latest reply on Oct 15, 2014 by philmodjunk

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

Outcomes