From the course: FileMaker Pro 13 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 13 Essential Training

Start my 1-month free trial

Establishing search operators

One good thing to know about doing finds in FileMaker is that when you're searching for your data, you don't always have to specify the exact criteria. We looked at that before when I put in partial words in, like LOS, and I get Los Angeles, for example. But, for example, if I want to find all of the invoices in this untitled 12_03 data base that we created. And let's say I want to look at all the invoices between the year 2000 and the year 2010. I don't actually have to go create ten new Find Requests. So, for example, I won't have to go in here and say, Invoice Date, 2000. Another Find Request. 2001. And by the way, notice here that when I'm typing in just the year, even though if I enter data into a date field and I typed in just a four digit number it would reject that because it doesn't meet the requirements of a date field which is a two digit day, two digit month, and a four digit year. But in Find mode, I can just type in a four digit year and FileMaker's intelligent enough to…

Contents