find returns too many records

[jlpalme]

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!

[mz123]

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

[jlpalme]

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

[mz123]

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.

[Raybaudi]

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

[jlpalme]

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!