Search for just Day and Month for birthdays

[aapl]

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.

[bcooney]

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.

[aapl]

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

[comment]

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'.

[comment]

See also:

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

[aapl]

Many thanks, This works perfectly!