Microsoft Dynamics 365 | Integration, Dataverse...

Calculate and populate school grade from date of birth

(0) Share

Report

Posted on by KING.EIKAIWA

I can calculate a contact's age from their date of birth, but I would now like to calculate their school year.

In this country the new school year starts on April 2nd and the students' age on that date determines their school grade/year.

So firstly, I need to calculate their age on April 2nd of the current year.

I then need to link this to their school grade i.e. 'if age 13 on April 2nd of current year' automatically populates another field with 'Junior High School Grade 2'

Any help with formulas for Dynamics 365 would be appreciated.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

LeoAlt 16,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi partner,

According to your description, I suggest you to use js function to do this beacuse it's very convenient and it can be flexible according to your needs.

Here is the sample code for you.

function getGrade(executionContext) {

    var today=new Date();

    var month = today.getMonth() + 1;//Get current Month

    var day = today.getDate();//Get current Day

    //If today is 04-02, then set the grade/year

    if(month==4&&day==2){

        var formContext = executionContext.getFormContext();

        var birth = formContext.getAttribute("new_Birthday").getValue();

        var birthDayTime = new Date(birth).getTime();

        var nowTime = new Date().getTime();

        var age = Math.ceil((nowTime - birthDayTime) / 31536000000);

        if(age==13){

            formContext.getAttribute("new_gradeyear").setValue("Junior High School Grade 2");

        }

    }

}

You said that you only want this function run at 04-02, but in D365 we could not specifies that the code is executed on a particular date, so I add this function in form onload event and if today is 04-02, it will trigger the function.

Hope it helps.

Best Regards,

Leo

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I agree with the authors above. I used the js function that was for my project. But the js function wasn't activated for a long time until I used an additional plugin for it. I got the manual from my programming teacher, who was implementing this project with me. I want to show him the code in the picture above. I think he'll approve and work on the implementation.

Was this reply helpful? Yes No
Community member 12 on at

Like (0)

Report
Copy link

Link copied!

brilliant solution! Converting birth dates to school grades is an innovative approach that simplifies academic records. But if you pay for essay at RoyalWriter.co.uk then it deserves praise. As a satisfied user, I appreciate their expertise and commitment to excellence. The seamless integration of technology and education is truly remarkable. Thank you RoyalWriter.co.uk for consistently providing quality services.

Was this reply helpful? Yes No