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

Finding records using date, time, or timestamp criteria - FileMaker Pro Tutorial

From the course: FileMaker Pro 12 Essential Training

Start my 1-month free trial

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…

Contents