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.