# find returns too many records

## Recommended Posts

hi.

i am a researcher in a developmental psychology lab and we use filemaker to store our participants information. we need to be able to search for potential participants based on their age in months. however, if we search in the "age" field for 2...9 and expect that to return subjects that are between 2 and 9 months old, we actually find that it returns all children that are either 2-9 months old, but also 20-99 months old and 200-999 months old.

we are using filemaker 7 and the problem occurs on filemaker 8 as well. the field is a calculation based on the current date and the child's birth date.

thanks!

##### Share on other sites

Is the calculation set with a result to "Number" and not "Text"?

##### Share on other sites

Age is calculated in a few different ways depending on the lab. The problem happens using both of these calculations:

Let(DateNow = Get(CurrentDate);

(Year(DateNow) - Year(Birthdate)

- If(DateNow < Date(Month(Birthdate); Day(Birthdate); Year(DateNow)); 1; 0))

* 12 + Mod(Month(DateNow) - Month(Birthdate) + 12

- If(Day(DateNow) < Day(Birthdate); 1; 0); 12)

)

Let(Today = Get ( CurrentDate ); (Today - Birthdate) / 30.4)

Thanks for the quick reply!!

Jen

##### Share on other sites

But if you open the window where the calculation is set, what does it say at the bottom. There is a pop-up that tells you what the result type is.

##### Share on other sites

...but the result of those calculations is stored as text or number ?

##### Share on other sites

what a simple solution. changing it to number fixed it. i had thought that b/c it was a calculation it would be stored as a number.

thanks!

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×

×
×
• Create New...

## Important Information

By using this site, you agree to our Terms of Use.