From the course: FileMaker Pro 14 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Establishing search operators

Establishing search operators - FileMaker Pro Tutorial

From the course: FileMaker Pro 14 Essential Training

Start my 1-month free trial

Establishing search operators

- When you're doing searches in FileMaker, you don't always have to specify the exact criterion. For example, if I want to find to find all of the invoices that were created between the year 2000 and 2010, I could go into Find mode, and I could enter dates into the Invoice Date, and do a whole bunch of New Requests if I want. Or, I could use what FileMaker calls its Search Operators. I'll show you how this works. I'm going to click inside the Invoice Date field, and I'll type in a date range, 1/1/2000. And then I'm going to click here under Operators, and find range, and then enter 12/31/2010. Now, when I hit Perform Find, FileMaker interpreted that as a range, because I was using the Operators instead. Let's take a look at some of these other Operators. Here's one that I think is kind of interesting, the = sign, or even the == sign. What that does, is find the exact match for what ever term follows it. But what I use it for, and I think you'll find this interesting as well, is that I…

Contents