case calc for age range.

[grumbachr]

Not sure what I'm doing wrong but as in the past these seems very easy for others. Below is my calc. I need to find males between the age of 18 and 24 and females between the ages of 16 and 24.

My "c_Curent_Age" field just stores their age in number of years. so 12, 13, 14... its not a FM date.

"Unstored, from Contact, = Case (

Contact::Gender ="male" and c_Current_Age ≥ 18 and not c_Current_Age < 25; "male" ;

Contact::Gender ="female" or "Female" and Contact::c_Current_Age ≥ 16 and not Contact::c_Current_Age < 25; "female" ;

"" ) "

As always your suggestions are greatly appreciated.

[comment]

The "not" seems peculiar.

Also, if this a calculation in Contact, why are the referenced fields in the form of related fields?

Edited October 2, 2007 by Guest

[grumbachr]

see i knew it would be easy.

taking out the not ( i tried it with and without before) and cleaning up the calc after moving it from one table to anther its working.

thanks a million

[comment]

Good. BTW, the empty default result is not required.