I'm working with FileMaker Pro, it's a few years old (2014? I think), and I am trying to perform a 'Find' by a date range. I work for a real estate company and we are trying to pull upcoming lease records for leases that need to be renewed in the next six months.
In the Layout I created I have a 'Lease Ending' Section, so I've gone in and hit 'Find' and then used the 06/30/2018...11/30/2018 parameters to try and find all leases with an ending date between those months. For some reason it either brings nothing back and says 'Modify Search' or it brings back leases from years ago and some from when I actually want.
I've also tried searching for Lease End Dates that are greater than 06/30/2018. That doesn't work either.
I'm not sure what exactly I'm doing wrong at the moment. If someone could help that would be great, as my boss would really appreciate these numbers soon.
Thank you for any and all helpful suggestions!