Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Select School Years from a Date Range

712 0
cancel
Showing results for 
Search instead for 
Did you mean: 
jennm
4 - Data Explorer
4 - Data Explorer

I am trying to build an automation or formula for this scenario:

  1. Student #1 has been enrolled in school from the dates 7/1/2018-6/30/2023. I have a field in this table (Students table) for Enrollment date (7/1/2018) and graduation date (6/30/2023). I need the field " School Years" to populate with the respective school years this student was in school for. Ex: SY 2018-2019, 2019-2020, 2020-2021, 2021-2022, 2022-2023 - this is a multiselect field. This will be unique for every student, as their enrollment and graduation dates are varying...

I have build a table named School Years and have the start and end date for each school year as a record. I would love this to be automated so that every time we have a new student and their graduation date changes, it will update what school years they were here for.

This seemed so easy to do in my head and I have tried every way to get this to work, but I cannot seem to figure out how to have ALL school years they were enrolled for to show up in a single field as separate school years.I've attached a photo of what I hope it to look like. Please help

0 Replies 0