4,401
edits
Changes
no edit summary
To count business days between two dates, the following code can be used in a [[Custom Field Type (103): Special – Browser Script|Special Browser script]] field that will populate a [[Custom Field|custom field]] with the number of business days between two given dates.
<pre>
function busdatediff()
{
var frm=document.form1;
var formatstr="dd/mm/yyyy";
var start=ConvertDateStr(frm.startdate.value,formatstr);
var end=ConvertDateStr(frm.enddate.value,formatstr);
var diff=datediff(start,end, "D");
var i=0;
var busday=0;
for(i=0;i<diff;i++)
{
var cdate=dateadd(start,'D',i);
if(!isHoliday(cdate))
busday++;
}
frm.cf_56262.value=busday;
}
busdatediff();
</pre>
[[Category:Custom Fields]][[Category:Applicant Tracking]][[Category:Enhancements]]
<pre>
function busdatediff()
{
var frm=document.form1;
var formatstr="dd/mm/yyyy";
var start=ConvertDateStr(frm.startdate.value,formatstr);
var end=ConvertDateStr(frm.enddate.value,formatstr);
var diff=datediff(start,end, "D");
var i=0;
var busday=0;
for(i=0;i<diff;i++)
{
var cdate=dateadd(start,'D',i);
if(!isHoliday(cdate))
busday++;
}
frm.cf_56262.value=busday;
}
busdatediff();
</pre>
[[Category:Custom Fields]][[Category:Applicant Tracking]][[Category:Enhancements]]