Hello everyone,

I have a simple database with just two linked tables. One field contains
a date of birth field. I then have a calculated field that determines
the age of the person. What I want to do is list anyone who has a
birthday on the current date. I know how to get the day, month and year
from the date of birth and the current date, but how do I list everyone
whose birthday in on the current day and month?

Any help would be very gratefully received.

Kev

"Kevin Warner" <me (AT) home (DOT) com> schreef in bericht
news:me-9197C2.16285212032010 (AT) news (DOT) iinet.net.au...
Depending on your needs you can create a FIND

or create a relationship and a portal, showing all related birthdays


--
Keep well / Hou je goed

Ursus

This would make more sense if you provided more info on your table names and
use but to further explain the reply from Ursus;

the find method will be best if you're going to send emails, etc...

(in suedo code)
enter find mode
set field 'birthday' to get(currentdate) <<this is assuming that your
birthday field is a date type>>
perform find

or setting up a portal if you're just displaying the information

you would set your relationship from a gloabl date field (ex- gBirthday) in
your 'control' or 'pref' table to the birthday field in your contacts (?)
table. Setup your portal to view records from the relationship/TO name then
populate the gBirthday field with get(Currentdate)

Hope this helps
Steve


"Ursus" <ursus.kirk (AT) ziggo (DOT) nl> wrote

Kevin Warner <me (AT) home (DOT) com> wrote:

You can search a date field for a day and a month in any year by
entering dd/mm/* or mm/dd/* depending on your date format settings. Test
the search, script it if it works.

If (in a scripted search) you use a calc field to extract the day and
month of today's date, make sure it's an _unstored_ calc field. Only un
unstored calc field can use get ( currentdate ) and actually get the
current date. A stored calc will store the creation date of the field be
done with it.

If you want to use a relation you could create a text result calc field
that calculates mmdd from the current date and similar calc field that
does the same with the birth date. The first field must be unstored (see
above), the second needs to be stored to make the relation work.

Now you can relate the two fields to and use GTRR, a portal or the list
function to see who's birthday it is.
--
http://clk.ch

Thanks for the help, it works just the way I wanted!