Greetings,

First experience with FileMaker Pro, but I'm bumming because I
can't do simple date comparisons. From the dozens of other threads
I'm not the only to find date handling frustrating.

Here's what I am trying to do. Write a script that will look at a
person's birth date and returns all records one month short of when
the person will turn 18 years of age (based on todays date). Product
seems robust enough to handle this, but man it's really bumming me
out that it's not straightforward.

Am I asking for too much?

Thanks in advance to anyone who takes the time to help me with this.

aww91 (AT) yahoo (DOT) com wrote:
below to download a sample file which will show you one way to do this.
My file shows all birthdays that fall within 30-days of 18 years. If you
want only the birthdates which are exactly 30-days within 18, a slight
modification to the relationship is all that is needed.

http://www.thehomecomputerdoctor.com...ay_tracker.zip

Michael Myett

<aww91 (AT) yahoo (DOT) com> wrote:

Ever tried the manual?

I did things like that in spread sheets, Access and Filemaker, it's the
same procedure everywhere.

I assume you have a date field with the birth dates.

Now you create a field that returns returns the month of the birth date.
This is a calc field.

Then you create a field that to calculate the age. Will look like
year(get system date)-year(birth date).

Now you're set. In order to get the list, you search for age and month
and sort by month and birth date.

--
http://clk.ch

Thank you Michael for your reply, and your sincerity in helping me with
my problem instead of assuming that I didn't do any research before
posting my question. Kudos to this to group.