AnsweredAssumed Answered

Date Find Request

Question asked by jb362 on Sep 27, 2012
Latest reply on Sep 27, 2012 by philmodjunk


Date Find Request



     I’m having trouble with the Specify Find Requests dialog.

     Here’s what I want to do…

     Find Task records where the Drop Dead Date is within the next 30 days.

     In my script I have defined $Interval as being 30.

     I tried Tasks::Drop Dead Date ≤ Get(CurrentDate) + $Interval.

     Also Tasks::Drop Dead Date ≤ {{CurrentDate}} + $Interval.

     FileMaker is not happy with either and says I must enter a valid date.

     Could you please enlighten me?