A READER ASKS: Reporting Between Two Dates

From Dwayne Wright PMP
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

Please Note: If you are viewing this page in a news feeder, the images may get munged up a bit or other formatting of the posting may fail. For the best experience, please visit the journal directly by clicking (here).

It has been years since I have used Filemaker and while conducting a web search on running reports in FMP, I came across your site. Would you please refresh my memory - how do I run a report for specified dates? For example, I'd like to find out which contacts were active during 2007.

Basically, you want to use the range operator, that can be found in the status area while you are in Find mode. You can do a special find operation in FileMaker to return anything between two specified dates in a date field. To do this, go to find mode, click in the date field, type in beginning date, then type in 3 period characters ( ... ) and then type in the ending date. This will bring up a found set of records between those entered dates in the date field you searched.

Here you can see the search options in the status area in Find mode and the selected range symbol.
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2008 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.