Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) How to add a field “Va...

How to add a field “Validity Duration” on the form. and set it automatically as the calculated duration between Valid From and Valid To (in hours and in days)

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hey I need to know how can i do the validity duration and set it automatically as the alculated duration between Valid From and Valid To (in hours and in days) using JavaScript..

*This post is locked for comments

All responses (5)

Answers (1)

Community Member Microsoft Employee on at

Like (1)

Report

RE: How to add a field “Validity Duration” on the form. and set it automatically as the calculated duration between Valid From and Valid To (in hours and in days)

Mark the answer verified if it answers your question
Community Member Microsoft Employee on at

Like (0)

Report

RE: How to add a field “Validity Duration” on the form. and set it automatically as the calculated duration between Valid From and Valid To (in hours and in days)

Thank you Saad
Verified answer

Community Member Microsoft Employee on at

Like (1)

Report

RE: How to add a field “Validity Duration” on the form. and set it automatically as the calculated duration between Valid From and Valid To (in hours and in days)

If you want to set duration days and hours in same field then this filed should be Single Line of text. Use this script:

function DateDiff() {

var start = Xrm.Page.getAttribute('validfrom').getValue();

var end = Xrm.Page.getAttribute('validto').getValue();

// to cancel the error when undefined

if (start == undefined || start == null || end == undefined || end == null) {

return;

}

// Get 1 hour

var hour = 1000 * 60 * 60;

// Get time in hours

var hours = ((end - start) / hour);

// get Time in days

var daysToSet = Math.floor(hours/24);

// Get hours to set

var hoursToSet = hours % 24;

// Can't be less than 0.

if (daysToSet < 0)

daysToSet = 0;

if (hoursToSet < 0)

hoursToSet = 0;

var duration = daysToSet.toString() + " " + hoursToSet.toString();

// Set the duration

Xrm.Page.getAttribute('duration').setValue(duration);

}
Community Member Microsoft Employee on at

Like (0)

Report

RE: How to add a field “Validity Duration” on the form. and set it automatically as the calculated duration between Valid From and Valid To (in hours and in days)

I have in my form 2 fields : Valid to & Valid from, I need to calculate the Validity duration using java script; For example the time consumed doing a task
Community Member Microsoft Employee on at

Like (0)

Report

RE: How to add a field “Validity Duration” on the form. and set it automatically as the calculated duration between Valid From and Valid To (in hours and in days)

Please elborate what you want to achieve with an example. Unable to understand validity duration