Look up FileMaker Pro's help on finds in date field. There is some pertinent information on the use of wildcards which will solve your problem. There is actually no need for the calculation fields you mentioned.
You can launch a script upon opening a file. Look at the "File Option" menu item.
I hope this is just the right kind of "push" you were looking for.
2) Depending on how you want to search, just grab the year from the date field like:
Right ( DATEFIELD ; 2 )
3) Create a new field CALCULATION and combine the month & day & year
4) Now you can create a script to find all records that match that date for today (perform find script):
5) Set the new script to run when you open the program and you should be all set.
You COULD save a step from above but the logic is a bit long.
SORRY - if your date is already ONE field then you only need to write the PERFORM FIND script for todays date "//" and run at launch.
Another approach for dates:
Define a cBirthday calculation field as: Date ( Month ( BirthDateField) ; Day ( BirthDateField ) ; Year(GetCurrentDate)) // Make this an unstored calculation.
Now you can simply compare this field to today's date (Get (CurrentDate) ) to identify birthdays falling on today's date.