From the course: FileMaker Pro 12 Essential Training
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Finding records using date, time, or timestamp criteria - FileMaker Pro Tutorial
From the course: FileMaker Pro 12 Essential Training
Finding records using date, time, or timestamp criteria
Another of the useful benefits when you're searching in FileMaker, are what are called date and time range searching capabilities. You'll see here in our exercise file that we've got a list of invoices and they contain some fields that have date, time, and timestamp values. We've worked with the Invoice Date in previous movies, but there are some interesting enhancements inside Search mode that you might not be aware of. I showed you one example where we could just type in a four-digit date inside in Date field, and it recognizes that four-digit date as a year. If you put a one or two-digit date in here it will search for records using that one or two-digit number in a Date field as the month, so it will actually search for this month in the current year, which we don't have any of those, but if you look here when you search, you see it does 6 and then a wildcard character and then another / and 2012, so those are just some shortcuts that you should be aware of. However, if I try to…
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.