The Secret Life of Find Mode: Dates and Times

Date values (and to a lesser extent, time values) are exceptionally common in database applications. And it isn’t at all unusual to want to ask you database interesting date-related questions, like “How many orders do we get on Tuesdays?” or “What was our total enrollment for the first quarter?” In fact, it is probably more common to look at ranges of dates than any particular date. Of course, if you’ve read our [previous articles](http://sixfriedrice.com/wp/the-secret-life-of-find-mode-requests/) on Find mode, you know how to find whole ranges of dates easily using find symbols. But FileMaker Pro’s Find mode has several date-specific tricks up its sleeve. Using some not-so-obvious syntax, you can easily search for *date slices* like every tuesday, or the 5th of every month, or every January. This short article will explain how.

Read more

FileMaker Pro 9: The Missing Manual Now Available

We’re thrilled to let you know that FileMaker Pro 9: The Missing Manual is now available for sale. This sequel to the best selling FileMaker book out there was written by yours truly (Six Fried Rice co-owner Geoff Coffey), and the amazing Susan Prosser. You can read more about it [here](http://sixfriedrice.com/wp/products/filemaker-pro-missing-manual/) where you can also find a free sample chapter.

Read more

The Secret Life of Find Mode: Symbols

Once you’ve mastered [multiple requests](http://sixfriedrice.com/wp/the-secret-life-of-find-mode-requests/), you’re ready to move on to the next Find Mode gem: Find Symbols. Using these bits of punctuation, you can tell FileMaker, when it goes about matching records to your find criteria, to be a little more flexible, or a little more strict. In this article, you’ll learn about each one.

Read more