Jump to content
Sign in to follow this  
jlpalme

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.

any advice would be helpful.

thanks!

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
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 this post


Link to post
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 this post


Link to post
Share on other sites

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

Share this post


Link to post
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!

Share this post


Link to post
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

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

Sign in to follow this  

×
×
  • Create New...

Important Information

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