From the course: FileMaker Pro 15 Essential Training

Unlock the full course today

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

Find records using date or time or timestamp criteria

Find records using date or time or timestamp criteria - FileMaker Pro Tutorial

From the course: FileMaker Pro 15 Essential Training

Start my 1-month free trial

Find records using date or time or timestamp criteria

- [Voiceover] FileMaker has some interesting features when you're searching specifically inside date or time fields. So, if you open up your exercise file, you'll see that I have a layout here called invoice list, and it contains some fields that have date and time stamp values, specifically here, the invoice date. And I've even got a ship time value. So what's interesting here is that FileMaker will allow you to enter in certain syntax in a search criteria, into a date field or a time field, that it won't normally allow in data entry. So, that allows us to do some kind of interesting things. So, let me show you some examples first. You'll notice in the invoice date field, there's several different dates as we scroll all these records. But, if we go into find mode, I'm gonna do something here where I type in just the number six. I would not normally be allowed to enter just the number six if I was doing a data entry into a date field, but let's see what I get back. Well, what this…

Contents