Microsoft Dynamics CRM (Archived)

Calculate end date from start date and duration

(0) Share

Report

Posted on by LiveBomb

710

Hello,

is there way how to calculate end date from start date and duration? Duration is in working days.

Thanks for help

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Karth on at

Like (0)

Report

Hi,

This isn't possible Out of the Box. You need to achieve this either by client side scripting (OnSave event) or through Plugins. My recommendation is to achieve this though plugins.

The business logic is fairly simple, but could get complicated when you bring in the business working days and hours into consideration.

Hope this info helps.

Thanks,

Karth

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

See Karth's answer. Do consider business closure dates when implementing working days in CRM. Business Closure dates can be found in Settings -> Business Management.

Was this reply helpful? Yes No
LiveBomb 710 on at

Like (0)

Report

So, i tried

function count_date () {

if (Xrm.Page.getAttribute("duration").getValue() != null) {

var enddate = Xrm.Page.data.entity.attributes.get("date_of_end")

var stardate = Xrm.Page.data.entity.attributes.get("date_of_stard")

var duration = Xrm.Page.data.entity.attributes.get("duration");

enddate.setDate(startdate().getDate + duration().getValue)

}

}

but not working.

Was this reply helpful? Yes No
Verified answer

Vijay Waghmare on at

Like (0)

Report

You can use something like below to set end date, but as mentioned by Karth and Eyup, you need to consider working days in calculation

if (Xrm.Page.getAttribute("duration").getValue() != null) {

var startdate = Xrm.Page.getAttribute("startdate").getValue();

var duration = Xrm.Page.getAttribute("duration").getValue();

var enddate = new Date();

enddate .setTime(startdate .getTime() + (duration * 24 * 60 * 60 * 1000));

Xrm.Page.getAttribute("enddate").setValue(enddate );

}

Thanks,

Vijay Waghmare

Was this reply helpful? Yes No