Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here




can anyone tell me how to extract a birthday list for a specified month.  all birth dates have been entered as normal date fields - i can't work out how to filter them just to get a desired month report

RE: birthdays

Make one field - calculation, text


Make the filter bades on this field and you will have all the birthdates for a given month.

RE: birthdays

Thanks Jean sorry but i'm new to filemake and not a programmer but i'm working out the basics.  My birthday field i have named DOB do i have to create a new field? and what sort of formula do i put in to tell it to just find the month and not the year or day?

RE: birthdays

Let stay on basic level, there are other ways to accomplish it, but with this you still can follow the logic.
Later on you can use other techniques....

You have your DOB field, which is of type 'date'.
Create a new field; monthDOB_ct.
It is a calculation, result text.

In the calculation window, in the upper right pane, you have all the functions.
Scroll down untill you find MonthName(date).
Double click and the function will appear in the calc box, with date highlighted.

Scroll down in the left pane, where all the fieldlabels are, untill you find your DOB field, double click.

( data ) will be replaced by ( DOB ).
Make sure to change the calculationresult to text in the lower left box before clcicking OK.

Back to your layout, put this new field on the layout.
This is the field to search on.
Go in to Find mode, give a month in this field and FileMaker will give you all the records with that month.

I never let users search on a data entry layout, I always redirect the user to a special searchlayout, where I put all the fields from the given table where it is allowed to search on, but that's another story.

Instead of monthName you can use Month( date ) instead, this will return the monthNumber instead of the name.
The way of working is the same.

If problems, feel free

RE: birthdays

Jean - thank you, thank you, thank you it worked perfectly.  Very much appreciated clown

RE: birthdays


Maybe I'm not understanding the question properly but maybe the solution for you is as simple as this:

1. Go into the find mode.
2. Type: 2/*/* into the DOB field.
3. Execute the find.

This should produce a found set for everybody with birthdays in February.


RE: birthdays

Well... looks like i weighed-in a mere 6 minutes late.

I should also mention that the method I described above *may* not work on older versions of FM.  It should work on 8.5 and perhaps 8.0 as well.


RE: birthdays

Hey Striker...long time no see...

Yes, you're right, x/*/* will give also the month, even in FM 8.

Here I wanted to stay on the 'didactic' way and combine calculation, text result and use of functions in one move.

Sometimes the quick solution for us, long time users, is missing the logic new users need.

In Kindness

RE: birthdays

Hi Jean,

Like most things Filemaker--and programming in general for that matter--there is usually more than one way to skin-the-cat.  Your method does indeed provide more opportunity for learning which is obviously a good thing!

I really haven't been away for long as I tend to check in, oh, probably once a day but often don't have the time to respond or you have already done a very thorough job of addressing the question so I wouldn't be adding any value.

Anyway, Merry Christmas to you Jean!  I wish you and your family all the best in the upcoming year.



RE: birthdays

>>-Striker :
>>..you have already done a job of addressing the question

Woops, have to slow down to give others (you) a chance...

Merry Christmas to you Striker!  I wish you and your family all the best in the upcoming year.
Happy FileMaking

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close