Home / SQL

SQL

Determining if Two Date Ranges Overlap

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.

An Introduction to Query Builder

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…