use the due date from the description of the RITM to set the RITM due date.

[C_S3]

Hello All,
We have to use the due date from the description of the RITM to set the RITM due date. Use that same due date (-2 weeks) for each of the tasks on that RITM.

I have created one BR for this but it's not working , please let me knowif I'm doing it wrong. 

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

    var string = current.description;

    gs.info("Due date" + string);

    var date = string.substring(string.indexOf('Due Date: ') + 11,

        string.indexOf('\n')); //if the date ends with a new line

    gs.info("string" + date);

    var dayMonthYear = date.split("/");

    var gDate = new GlideDateTime(dayMonthYear[2].trim() + "-" + dayMonthYear[0].trim() + "-" + dayMonthYear[1].trim() + " 12:00:00");

    current.due_date = gDate;

    current.update();

})(current, previous);

Any help would be appreciated .Thank you!

[Rajesh Chopade1]

hi @C_S3 

Try bellow updated script once:

(function executeRule(current, previous /*null when async*/ ) {
    // Ensure the description contains "Due Date:"
    if (current.description && current.description.indexOf('Due Date:') !== -1) {
        var string = current.description;
        gs.info("Original Description: " + string);

        // Extract the due date
        var dateStart = string.indexOf('Due Date: ') + 11; // Start after "Due Date: "
        var dateEnd = string.indexOf('\n', dateStart); // Find the end of the date
        var date = string.substring(dateStart, dateEnd !== -1 ? dateEnd : string.length).trim(); // Trim to avoid spaces

        // Log extracted date
        gs.info("Extracted Due Date: " + date);

        // Convert the extracted date to a GlideDateTime object
        var dayMonthYear = date.split("/");
        if (dayMonthYear.length === 3) {
            // Create the GlideDateTime
            var gDate = new GlideDateTime(dayMonthYear[2].trim() + "-" + dayMonthYear[0].trim() + "-" + dayMonthYear[1].trim() + " 12:00:00");

            // Adjust due date by subtracting 2 weeks
            gDate.addDays(-14);

            // Set the RITM due date
            current.due_date = gDate;

            // Update the RITM
            current.update();

            // Now set the due date for each task associated with this RITM
            var taskGR = new GlideRecord('sc_task');
            taskGR.addQuery('request_item', current.sys_id);
            taskGR.query();
            while (taskGR.next()) {
                taskGR.due_date = gDate; // Set the same due date for the task
                taskGR.update(); // Update the task
            }
        } else {
            gs.error("Failed to parse the due date from the description.");
        }
    } else {
        gs.warn("Description does not contain 'Due Date:'. No action taken.");
    }
})(current, previous);

i hope my answer helps you to resolve your issue, if yes please mark my answer helpful and correct.

thank you

rajesh

[C_S3]

Hello @Rajesh Chopade1 ,
Thank you for your quick response. I have tried the above script in After, insert, update BR. But I'm getting today's date in due date field of RITM.

[Rajesh Chopade1]

Ensure that the date extracted from the description is in the correct format. If the format is not recognized, it may default to today's date.

Make sure the Business Rule is set to execute after the record is inserted or updated, but also check if it is configured to run for the correct table (e.g.,  sc_req_item).

Try bellow script once :

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

    // Ensure the description is not empty
    if (!current.description) {
        return;
    }

    // Extract the due date from the description
    var string = current.description;
    var dueDateMatch = string.match(/Due Date:\s*(\d{1,2}\/\d{1,2}\/\d{4})/); // Adjust regex to match your format

    if (dueDateMatch && dueDateMatch[1]) {
        var dateStr = dueDateMatch[1]; // Get the matched date string
        var dayMonthYear = dateStr.split("/");

        // Create a GlideDateTime object
        var gDate = new GlideDateTime();
        gDate.setValue(dayMonthYear[2].trim() + "-" + dayMonthYear[0].trim() + "-" + dayMonthYear[1].trim() + " 12:00:00");

        // Set the due date
        current.due_date = gDate;
        gs.info("Due date set to: " + gDate);
    } else {
        gs.info("No due date found in description.");
    }

})(current, previous);

[C_S3]

Hello @Rajesh Chopade1 ,
I'm still getting today's date . I'm attaching description's image.