below js function to calculate number of leave days excluding weekends(saturday & sunday) and set this on change of end date and it works.
function calculatedays()
{
var startDate;
var endDate;
var d = Xrm.Page.data.entity.attributes.get("new_start_date").getValue();
if(d!=null)
var d1= d.getDate();
var d2= d.getMonth();
d2++;
var d3= d.getFullYear();
startDate =d1+"/"+d2+"/"+d3;
var firstDate = new Date(d3,d2,d1);
var fms=firstDate.getTime();
}
else{
alert("Give Start Date");
return false;
}
var end = Xrm.Page.data.entity.attributes.get("new_end_date").getValue();
if (end != null) {
var e1= end.getDate();
var e2= end.getMonth();
e2++;
var e3= end.getFullYear();
endDate=e1+ "/" + e2+ "/" + e3;
var secondDate = new Date(e3,e2,e1);
var ems=secondDate.getTime();
}
var range_date_off=[startDate,endDate];
var d1 = parseDate(range_date_off[0])
var d2= parseDate(range_date_off[1])
var days= [];
for (var dt = d1; dt <= d2; dt.setDate(dt.getDate() + 1)) {
var fdt = new Date(dt)
var a=new Date(fdt.getFullYear(),(fdt.getMonth()),fdt.getDate());
if(a.getDay() != 6 && a.getDay() != 0)
{
days.push ( fdt.getDate() + "/" + (fdt.getMonth() + 1) + "/" + fdt.getFullYear());
}
}
var leavedays=days.length;
alert("you have leave"+leavedays);
Xrm.Page.data.entity.attributes.get("new_number_of_day").setValue(leavedays.toString());
// Xrm.Page.getAttribute("new_number_of_day").setSubmitMode("always");
}
function parseDate(input) {
var parts = input.match(/(\d+)/g);
return new Date(parts[2], parts[1]-1, parts[0]);
}
*This post is locked for comments
I have the same question (0)
