Student's Age As of Sept 1st

Moriah Petersen Griffin
Moriah Petersen Griffin Community All-Star
Second Anniversary Kudos 1 Name Dropper Participant
in Blackbaud Student Information System™

I'm looking for a way to quickly determine a student's age as of September 1st. We use this information to determine which grade level the student is eligible for and I can't seem to find a way to do that in Blackbaud so far. Any thoughts or suggestions?

Thanks!

Moriah

Comments

  • Brian LeBlanc
    Brian LeBlanc
    Kudos 5 Fourth Anniversary Name Dropper Participant

    @Moriah Petersen Griffin At what point in the process do you determine eligibility? In our case, we use an inquiry as the first step in the admissions process, and have a candidates list that we run to send an official note to respond to that inquiry. I always sort that candidates list by DOB and can quickly identify students who do not meet the age cutoff, and send a different official note to those students. Happy to demonstrate if you'd like!

  • Kim Ashcraft
    Kim Ashcraft
    Ninth Anniversary Kudos 2 Name Dropper Participant

    @Moriah Petersen Griffin
    I was intrigued by your question, so I looked at some Excel formulas to do this. Here is a small sampling of students with their age as of 9.1.23. Once I understood how the formula was working, I was able to do this for our whole student population in about a minute. If you are willing to export the names and birthdates into Excel, then perhaps this would be a solution for you. Start date is the student's birth date.

    If you want the formula, let me know and I'll send it. Kim

    c34394c5d09f619cb259a792528317f0-huge-im
  • Moriah Petersen Griffin
    Moriah Petersen Griffin Community All-Star
    Second Anniversary Kudos 1 Name Dropper Participant

    @Kim Ashcraft
    This is exactly what I was looking for! Do you mind sharing the formula? Thank you!

  • Kim Ashcraft
    Kim Ashcraft
    Ninth Anniversary Kudos 2 Name Dropper Participant

    @Moriah Petersen Griffin
    Not at all. I'm not sure whether you need the complexity of years, months, days. The formula is simpler if you don't do month and days. Also, I assume you know how to use Excel formulas, in general? This is a dateif formula that is concatenated. I'll copy it as I found it and also the formula with my cells inserted so you can see that. Let me know if you have any problems! Kim

    =DATEDIF(start, end, "y") & "y " & DATEDIF(start, end, "ym") & "m " & (DATE(YEAR(end), MONTH(end) - DATEDIF(start,end,"m"), DAY(end))-start) & "d"

    =DATEDIF(C22, D22, "y") & "y " & DATEDIF(C22, D22, "ym") & "m " & (DATE(YEAR(D22), MONTH(D22) - DATEDIF(C22,D22,"m"), DAY(D22))-C22) & "d"

    ede74d093aa5b8e0b3095e67807f4b7f-huge-im
  • Moriah Petersen Griffin
    Moriah Petersen Griffin Community All-Star
    Second Anniversary Kudos 1 Name Dropper Participant

    @Kim Ashcraft Perfect, thank you!

Categories