Good Morning,
I am using two date field from my Table Main to attempt to product results that are using the subject line operators with no luck. Here is what I have configured.
As you can see, the relationship from the Date field that is entered in as a Key for each record is linked to the Last 30 Days field which is also a Date field. The Last 30 Days is a calculated date field and here is how I have that configured.
I've researched the FMP online manual and know that the relationship is not finding any records and therefore not producing the results that I am looking for.
I have tried everything that I can possible think of to resolve this but have reached an end of ideas. Obviously I am doing something incorrect. Can anybody shed some guidance on what it is?
Thank you for your time and assistance.
Kevin
It is not clear which Table you are on and which one is related.
However, the issue seems like it is the sort on the relationship. You can change it in the relationship dialog. If the sort is the wrong order you will get the most recent date vs the furthest one away since they are all in the <= range.