222
Hi All,
I have requirement to calculate the time difference (in business hours/minute) between two date time fields in Dynamics 365. I have different business units in my organisation and which is under different time zone. Is there any way that I can get the time difference in business hours ?
Thank you in advance.
Regards,
Abhiram
*This post is locked for comments
hi try this
function DOBvalid() {
var oneDay = 24 * 60 * 60 * 1000;
var DOB = Xrm.Page.getAttribute("new_dob").getValue();
var Today = new Date();
var diffDays = Math.abs((DOB.getTime() - Today.getTime()) / (oneDay));
alert(diffDays);
/*var age = DOB
if (DOB > Today) {
alert('Date of birth can not be greater than the date today');
Xrm.Page.getAttribute("new_dob").setValue(null); //set null value
*/
}
Hi Abhiram,
You could try using a calculated field to calculate the difference between the two date time fields.
Or you could create a simple field with floating point number data type and populate the field using javascript.
See the links below.
community.dynamics.com/.../239306
crm.ipiyush.me/calculate-duration-fields-in-dynamics-crm-2011-via-code-javascript-and-c
Hope this helps.
Hi,
Thanks for your reply. I have tried to create one plugin for achieving the same by referring the below blog. However if the two dates are in the same day it is returning 0. If you have any blog/site reference please share.
crmmemories.blogspot.ae/.../calculate-working-time-between-two.html
Regards,
Abhiram
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (