how do I FIND records by the MONTH

[chagme]

This is a very simple problem. I've looked through my new manual and searched the web, but no luck.

I want to do a simple FIND on a DATE field that shows all records with month = September (for example) for any year.

Entries such as 9/**/**** return error messages.

Thanks.

 

[chagme]

Answering my own question here, so as not to waste others' time. I finally figured I can create another field that pulls the month from the date field and then do my searches on that field.

 

[Schlogg]

Or you could do a search on -
1/9/2003...30/9/2003

Cheers,
Paul J.