AnsweredAssumed Answered

Perform Find Script Help with Dates

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


Perform Find Script Help with Dates



     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,