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 - FileMaker Pro Tutorial
From the course: FileMaker Pro 15 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.