AnsweredAssumed Answered

Running a simple find between 2 different date fields

Question asked by KeithFletcher on Aug 30, 2012
Latest reply on Aug 30, 2012 by philmodjunk

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

Outcomes