AnsweredAssumed Answered

Need Help with Date Range that Isn't Working

Question asked by sappleyard15 on May 15, 2018
Latest reply on May 16, 2018 by beverly

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!