My intention is to be able to search for peoples birthdays between two sets of dates. For example between the dates "Greater than 01/01/NA" to "less than 15/01/NA". How can I search through dates for the day and month, It doesn't matter what the year is.

I am looking for a way to have a script which performs a find in the BirthDate field to find the results.

Hopefully someone can help me here.

Many thanks.

In FM11 (not sure of FM7), you can use wildcards in search. So, to find a birthday, simply search for 1/22/*, or 1/1/*..1/15/* or 1/*/* in Date of Birth field.

The problem is I am looking to find a range of dates.

When I search for:

>=01/01/2011 <=16/01/2011

I get a range of dates.

When I search for

>=01/01/* <=16/01/*

I get an invalid message.

Is there a work around here?

Many thanks

Like Barbara, I don't remember what works in version 7. In more recent versions, you'd use:

{1..15}/1/*

to find dates between Jan 1 and Jan 15 of any year (assuming your date format is D/M/Y).

See the built-in help for 'Finding ranges of information'.

See also:

http://fmforums.com/forum/topic/48048-birthday-reminder-how-can-i-do-it/page__p__224375#entry224375

Many thanks, This works perfectly!