AnsweredAssumed Answered

Comparison Between Two Date Fields in Same Table

Question asked by kevinburk on Jan 3, 2018
Latest reply on Jan 3, 2018 by kevinburk

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.

Outcomes