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.