koachie

Finding a particular age range based on years, months and days

Discussion created by koachie on Aug 22, 2018
Latest reply on Aug 22, 2018 by Mike_Mitchell

Hi everyone! 

 

I am building a gymnastics club management app which has a waiting list.

 

I am trying to create a script (rather than a button or dropdown menu) that allows me to find students based on the following age brackets:

 

  1. Students who are 0 years old to 1 years old
  2. Students who are 11 months old to 3 years old and 11 months
  3. Students who are 3 years, 10 months and 15 days old, to students who are 4 years old and 11 months
  4. Etc.

 

I have been able to create a script that finds students based on how many years old they are, i.e. 5 years old, 6 years old, etc. but for the purposed of the waiting list I need to be able to be able to offer a space to someone one month before they are old enough for the class.

 

I hope this makes sense and would greatly appreciate any help, tips or pointing in the right direction.

 

Thanking you in advance.

Outcomes