AnsweredAssumed Answered

Perform Find Script Help with Dates

Question asked by RyanSearle on Jun 4, 2014
Latest reply on Jul 31, 2014 by philmodjunk

Title

Perform Find Script Help with Dates

Post

     Hello, 

     I am using FileMaker Pro 12.0v5. One field in my database is an "Expiring Lease" field where I enter a date using the calendar function. I would like to be able create a Perform Find Script that searches for all the leases that will expire in the next 60 days by looking at the "Expiring Lease" field and comparing it with "today's date". Any suggestions on how to set up this script? 

     Thank you, 

     Ryan 

Outcomes