Age range variables

[#1]

Hi All,

I need to make a 2 input fields with variables, one "Age from" and second "Age till". This will be Age range. And for exapmple, when i in the firs field i enter 20, in second 35, it must retur 

only customers ho have age between 20-35. Please help.

my expresion is:  =count({$<LastMembershipDueDate={ "<$(=Date(Today(), 'YYYY.MM.DD'))" },OfferingCategory1={'Narystės'} >}distinct CustomerID )

[MK_QSL]

Can you post sample data or sample apps?

[#3 · Accepted solution]

count({$<LastMembershipDueDate={ "<$(=Date(Today(), 'YYYY.MM.DD'))" },OfferingCategory1={'Narystės'}, Costumer.Age = {>=$(minAge)<=$(maxAge)} >}distinct CustomerID )

hope this helps!

regards,

MT

[#4]

minAge and maxAge would be the name of your variables

[MK_QSL]

What is the definition of Min and Max Age?

[christian77]

Here are 2 ways of doing it

[#7]

like she posted at the beginning she has to input fields where she types in the min and max age! and and inputfield usually needs a variable to save the input value.

[#8]

Thanks all of you, i little modified Magdalens set analysis and it works

count({$<LastMembershipDueDate={ "<$(=Date(Today(), 'YYYY.MM.DD'))" },OfferingCategory1={'Narystės'}, Customer.Age = {'>=$(minAge)<=$(maxAge)'} >}distinct CustomerID