3 Replies Latest reply on Sep 27, 2012 10:53 AM by philmodjunk

    Date Find Request

    jb362

      Title

      Date Find Request

      Post

            

           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?

           Thanks.