Duration Calculation not working

[ceraulo]

Hello!

I have 2 date/time fields - Opened Date and Populated Date.

I have a before BR that populates the Populated Date.

I also have a Duration field.

I created an Update before BR which runs when the Populated Date is not empty. My script is:

(function executeRule(current, previous /*null when async*/ ) {

    getTimeDiff();

    function getTimeDiff() {
        var openDate = current.opened_date.getGlideObject();
        var popDate = current.u_populated_date.getGlideObject();

        current.u_duration = gs.dateDiff(openDate.getDisplayValueInternal(), popDate.getDisplayValueInternal(), false);
    }

})(current, previous);

This script is not working.

Please help troubleshoot the script.

Thank you.

[Omender Singh]

Please try this script - 

function executeRule(current, previous /*null when async*/ ) {

getTimeDiff();

function getTimeDiff() {
var openDate = current.opened_date.getDisplayValue();
var popDate = current.u_populated_date.getDisplayValue();

current.u_duration = gs.dateDiff(openDate, popDate, false);
}

})(current, previous);

[Snehangshu Sark · Accepted solution]

Hi @ceraulo ,

use the below script, it's tested.

function executeRule(current, previous /*null when async*/ ) {

getTimeDiff();

function getTimeDiff() {

current.u_duration = gs.dateDiff(current.opened_date.getDisplayValue(), current.u_populated_date.getDisplayValue(), false);
}

})(current, previous);

Regards,

Snehangshu Sarkar

Please mark my answer as correct if it resolves your query.

[ceraulo]

It worked when I used only this line of code in the BR:

current.u_duration = gs.dateDiff(current.opened_date.getDisplayValue(), current.u_populated_date.getDisplayValue());