I have a date field. How do I search for all records in a certain month. I
want to find all records for October over a several year peroid.

TJH

In article <dk515m$i8n$1 (AT) iruka (DOT) swcp.com>, "Tim"
<hawkdc9 (AT) removethis (DOT) swcp.com> wrote:

Make a calculation field where the calc is the Month function. It will
look like:

Month (YourDateField)

This field will then contain a single number, one through 12, depending on
the month. Run your find on this field, instead of your date field, and
you can get all records from October, any October.

Steve Brown

Tim wrote on (10/31/2005):

Create a calc field: YourMonth = Month ( YourDate ).

Perform the search on that field.

Look at Month function in Help for more info.

Matt

--

Tim wrote:
The other answers you've received are quite valid for FileMaker versions
prior to FM8. For FM8, though, it becomes much easier. In find mode,
just enter "10/*/*" (without the quotes). Or to find everyone with a
birthday today, use "10/31/*". Or to find everything that happened on a
Monday, you can actually search in the date field for the word "Monday"
(though this does NOT work in the same way for months).

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California

FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance