Seaching Dates 1

[steve5504]

I use FileMaker Pro 6 and have a database of over 4,000 records. My date field format is: mm/dd/yyyy and spands 5 decades. I am trying to come up with seach that will return a list of records a specific month for all the years (i.e. all records with the month of January). I tried 01/*/* and 01/??/????. Neither worked. Any ideals?

Thanks
SN

 

[jaco8867]

Create a new calculation field in the database using either:

Month(date field) returns 1-12
or
MonthName(date field) returns Month name as text

Hope that Helps