If you were to think in English (I'm assuming that English is your
primary language) about what you really want, isn't it that you want to
know when their next borthday is. Or more to the point, whose next
birthday is in the next 30 days.

So what is the next birthday? If the data has already passed this year,
then the date will be next year. Otherwise, the date will be sometime
between now and the end of the year.

To translate the english into FileMaker, create a calculation field that is:

if(
date(month(Birthday), day(birthday), year(status(currentdate))) <
status(currentdate),
date(month(Birthday), day(birthday), year(status(currentdate))+1),
date(month(Birthday), day(birthday), year(status(currentdate))
)

Now use your script with the (-30) and everything to find what you want
based on this new calculation.



Daniel R. Sloan wrote:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California
Associate Member, FileMaker Solutions Alliance

Success, how about Sort - Month / Day without year?

Daniel R. Sloan

In reply to byJTa.131370$N7.19332@sccrnsc03 on 7/23/03 9:48 PM by Daniel R.
Sloan danielsloan (AT) comcast (DOT) net:


FileMaker has a lot of built in date features.

Here is another approach that may be of use:

Field Name Field Type Formula / Entry Option
Birthday Date
NextbirthdayMonth Calculation (Number) = Month(Birthday)
NextbirthdayDay Calculation (Number) = Day(Birthday)
NextbirthdayMonthWarning Calculation (Number) = Month(Birthday - 30)

And you can sort by the month and day calculations

HTH

Lee

[posted and mailed]

I know this may be a little late but . .

I found the easiest way is to sort by month and date sans the year is to
use the following calculated field -

zc.SortDate(text): If( Month( Date ) < 10 , "0" ,"" ) & Month( Date ) &
"." & If( Day( Date ) < 10 , "0" ,"" ) & Day( Date )

you end up with a calculated result like 03.12 for a date of 3/12/2001 and
it should sort just fine.




"Daniel R. Sloan" <danielsloan (AT) comcast (DOT) net> wrote in news:byJTa.131370
$N7.19332@sccrnsc03: