JavaScript - Calculate Number of Business Days between Two Dates

(0) Share

Report

Posted on by Community Member

CRM 2013, looking for a JavaScript to calculate number of business days between two dates assuming 5 business days in a week.

Thanks for the help.

Rehal

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Guido Preite 54,086 Moderator on at

Like (0)

Report

you can use the momentjs library, for examples connected to Dynamics CRM check my blog post

www.crmanswers.net/.../momentjs-and-dynamics-crm.html

Was this reply helpful? Yes No
Suggested answer

Rawish Kumar 13,758 on at

Like (1)

Report

Hey Arvinder,

you can try below :

stackoverflow.com/.../find-the-number-of-business-days-between-two-dates-in-microsoft-dynamics-crm-201

however it wont be able applicable for bank holidays or other holidays in a week , i hope you are not expecting that too.

mark my suggestion as verified if helpful.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Hi Arv_rehal,

try the following, is a four line solution :-)

function DateDiff() { var datefrom = Xrm.Page.getAttribute("new_datefrom").getValue(); var dateto = Xrm.Page.getAttribute("new_dateto").getValue(); var days = (dateto - datefrom) / (1000 * 60 * 60 * 24); Xrm.Page.getAttribute("new_daydiff").setValue(days); }

Please let me know if you solve.

If you found the answer helpful, please mark as Verified

Join my network on LinkedIn Follow me on Twitter

Thank You & Best Regards

Francesco Picchi

Microsoft Dynamics CRM Consultant, Bologna+Milano, ITALY

Independent Contractor

http://www.francescopicchi.com

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

@Francesc, thanks for your code share. can you tell how we can minus weekends and only show business days?

thanks.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report
finally achieved this with the following ...

function LM (startDate, endDate) { var endDate = Xrm.Page.getAttribute("new_enddate").getValue(); var startDate = Xrm.Page.getAttribute("new_startdate").getValue(); var count = 0; var curDate = startDate; while (curDate <= endDate) { var dayOfWeek = curDate.getDay(); if(!((dayOfWeek == 6) || (dayOfWeek == 0))) count++; curDate.setDate(curDate.getDate() + 1); } Xrm.Page.getAttribute("new_leavedays").setValue(count); }

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks everyone for your replies.

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Here's the reverse - calculate end date from start and number of working days:

function calcEndDate(startDate,workdays){ var count = 0; var curDate = new Date(startDate.valueOf()); curDate.setDate(curDate.getDate() - 1); while (count < workdays) { curDate.setDate(curDate.getDate() + 1); var dayOfWeek = curDate.getDay(); if(!((dayOfWeek == 6) || (dayOfWeek == 0))) count++; } return curDate; }//calcEndDate

Was this reply helpful? Yes No