1 Reply Latest reply on Aug 30, 2012 9:13 PM by philmodjunk

    Running a simple find between 2 different date fields

    KeithFletcher

      Summary

      Running a simple find between 2 different date fields

      Product

      FileMaker Pro

      Version

      10

      Operating system version

      Windows

      Description of the issue

      This seemed simple until I tried it. I have 2 fields, one for Buydate and one for Selldate. All I am trying to do is run a quick find (not create a new field or script) that essentially asks to find all records where Selldate>Buydate or in other words where the Selldate accurs after the Buydate. The date fields are currently set as a date type of the mm/dd/yyyy variety.

      When I run the search, I search in the Selldate field and insert >Buydate but it returns an error that says the value of this field must be a valid date. Therefore I think the error is in how i am searching. I cannot seem to figure out how to refernece other fields in my simple find request.

      Thanks for any help.

      Expected result

      A list of records where the Selldate occurs after the Buydate.

      Actual result

      Error Message

      Exact text of any error message(s) that appear

      "The value of this field must be a valid date in the range of years 1-4000 and should look like 12/25/03