I need to be able to either create a calculation field or a custom filter that compares two date fields within a single record, so that I can isolate records where date A is greater than date B.
I've tried to create a calculation field based on the evaluation (which would give me something easy to filter on) but I keep getting "field not found" errors.
I'm sure this is a relatively simple process, but I'm new to FileMaker and don't understand how the scripting works.
CalcField = Case( Table::DateA > Table::DateB;1;0) // data type number
Then search on CalcField = 1