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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

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