AnsweredAssumed Answered

Date Relationships using <= or >= operators

Question asked by kdcattran on Feb 26, 2018
Latest reply on Feb 26, 2018 by erolst

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.

 

Tables.png

Relationship.png

 

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.

 

Last 30 Days.png

 

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.

 

Resutls.png

 

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

Outcomes