ExecuteSQL() can be very powerful in FileMaker, but you must use it correctly within its limits. Learn more from one of our certified FileMaker developers.
In some cases, a FileMaker developer needs to determine if two date ranges overlap. That is a daunting task with standard techniques using complex relationships or a long ExecuteSQL query. In this post, we examine a simple way to determine if two date ranges overlap. It solves some real-world problems and is extremely easy to use.
Mislav Kos explains how to use Query Builder, a FileMaker tool he created to help write ExecuteSQL expressions. The tool does not rely on a wizard; queries are typed out manually. Key features include automated formatting of queries, assisted troubleshooting, and easier table and field name abstraction. Read the blog post…