Find a specific month

[Bruno Dini]

Hello, I have a simple database, and one of the fields is a "date" field.

I have to make reports from month to month, how can i use the find tool to find only the records from that specific month.

Thanks!

[*susan*]

Bruno,

The simplest way is to do use the range expression;

2/1/2006...2/28/2006.

Or you could add a new field:

calculation, number result = Month(date);

or if you prefer the text equivilent:

calculation, text result = MonthName(date).

Put this field on your layout and search by 2, or by February.

*susan*

[LaRetta]

You can also use wild cards in your search (since version 8). Check FM Help for some cool examples. Be careful searching for just the month because you'll get all years. So to search a date field, you can type:

2/*/2007

I love the new wildcards feature but I forget to use it as often as I should. :smile2:

Edited February 12, 2007 by Guest