Running a simple find between 2 different date fields
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.
A list of records where the Selldate occurs after the Buydate.
"The value of this field must be a valid date in the range of years 1-4000 and should look like 12/25/03
This has been a known limitation of FileMaker Finds since the earliest versions of FileMaker. The work around is to define a calculation field such as Selldate > Buydate
and then search for a 1 in this field.