8,849
edits
Changes
no edit summary
function bus_date_subtract()
{
var frm=document.forms[0]form1; // or document.frmevent at Level 2 or 3 var formatstr="dd/mm/yyyy";
var start=ConvertDateStr(frm.startdate.value,formatstr);
var sub=-5;
{
var cdate=dateadd(start,'D',i);
var cdatetemp=new Date(); var cdatearr=cdate.split("-"); cdatetemp.setFullYear(parseInt(cdatearr[0]),parseInt(cdatearr[1])-1,parseInt(cdatearr[2])); if(!isHoliday(cdate)||cdatetemp.getDate()==0||cdatetemp.getDate()==6) sub--;
}
document.frmevent.cf_1742956 .value=cdate;
}
bus_date_subtract();
</pre>
In '''Expression''' section of the [[Custom Field Type: Special – Calculated Value|Calculated Value Custom Field]] you would call the function:
bus_date_subtract();
Note: The function definition can be changed to accept parameters (fields containing dates) that are passed at the time of calling the function from any [[Custom Field Type: Special – Calculated Value|Calculated Value Custom Field]].
==See Also==* [[Manipulating Dates]]* [[busdateadd]]* [[Custom Defined Holidays]] [[Category:Custom Fields]][[Category:JavaScript]][[Category:Date Formats]]