I'm wondering whether someone could help me out with the right syntax?
I have 2 apps - APP1 contains all the dates of 1 school year on which I can register a child to school. APP2 contains a birthdate and a calculation field that eventually should calculate the closest date that I can register my child to school. You can register for school at the age of 2,5y (30 months) - so what I need is the following:
STEP 1: birthdate (app2) + 30 months = ResultDate
STEP 2: compare the ResultDate with the closest register date from app1
STEP 3: show the closest date in the calculation field (app2)
So to give a concrete example:
My child is born on 13/09/2021. On 13/03/2023 it will become 2,5 years old and as of then, I can register my child to school. In the 2nd app I have 6 dates being 01/09/22, 07/11/22, 09/01/23, 27/02/23, 17/04/23 and 22/05/23. From the logic explained above the closest date after the child has become 30m would be 17/04/23. This is the date that I would like to get back in the calculation field.
Can anyone give me a hand on the syntax, please?
Many thanks in advance...
Please sign in to leave a comment.