Filter by age throught combo box (SQL)

Hello, I have a problem with a filter in a combobox.

This combox is used to filter by age: 0-18 years old, 18-50 years old... I don't know if static entity is the best way

What is the best way to have a search through sql, being that I only have the date of birth.

Thank you

Hey Petter,


If you go for the static entity approach the 0-18 and 18-50 could be 2 separate records. I would suggest to add 2 attributes to your static entity like MinValue and MaxValue where you specify the min/max age values and it would make it easier for you to perform SQL/Aggregate queries based on the selection.


Regards,

Bogdan

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.