Microsoft Dynamics CRM (Archived)

Add duration to time field

(0) Share

Report

Posted on by Jay2014

Hi All,

How do i go about adding a duration field to a time field.

For example one selects duration of 45 mins and time is 10:00 .. I want records this as 10:45.

Thanks,

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Ben Thompson 6,350 on at

Like (0)

Report
Copy link

Link copied!

A duration field is a whole number field that contains in the background a value in minutes.

To get the end date / time you can use either a workflow, flow or plugin to addminutes(duration) to the starting date field.

Was this reply helpful? Yes No
Suggested answer

Ben Thompson 6,350 on at

Like (0)

Report
Copy link

Link copied!

duplicate

Was this reply helpful? Yes No
Jay2014 on at

Like (0)

Report
Copy link

Link copied!

you cant add a duration to a time field using a workflow. The duration field is locked is locked down.

Any references to help me with Java Script / Plugin ?

Was this reply helpful? Yes No
Suggested answer

Sreevalli 3,264 on at

Like (1)

Report
Copy link

Link copied!

Hi,

go through the similar scenario community.dynamics.com/.../221343

Was this reply helpful? Yes No
Suggested answer

Alex Fun Wei Jie 33,628 on at

Like (0)

Report
Copy link

Link copied!

Hi,

you can refer below post on how to update a duration field using JS. But , if you are using CRM 9.0 above, remember using the execution context.

community.dynamics.com/.../802826

Was this reply helpful? Yes No
Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Try this-

===================

function setProgramEnd() {

var ProgramStartDate = Xrm.Page.getAttribute("new_programstartdate").getValue();

var ProgramDurationInMinutes = Xrm.Page.getAttribute("new_programduration").getValue();

var ProgramEndDate = new Date(ProgramStartDate.getTime() + ProgramDurationInMinutes * 6e4);

Xrm.Page.getAttribute("new_programenddate").setValue(ProgramEndDate);

}

==================

Hope this helps.

Was this reply helpful? Yes No