JavaScript for getting Total days between of two dates & Exclude the Saturdays and Sundays in total days.
Code:
              
Code:
function DateDifference() {
           
var startDate = document.getElementById('<%=
txtStartDate.ClientID%>').value;
           
var endDate = document.getElementById('<%=
txtEndDate.ClientID%>').value;
           
var startDateSplit = startDate.split("/");
           
var endDateSplit = endDate.split("/");
          
//getting Start Date,End Date
           
var stDate = new
Date(startDateSplit[2], startDateSplit[0] - 1, startDateSplit[1]);
           
var enDate = new
Date(endDateSplit[2], endDateSplit[0] - 1, endDateSplit[1]);
           
//getting difference B/W Start Date & End
Date
           
var difference = (enDate.getTime() -
stDate.getTime()) / (1000 * 60 * 60 * 24);
           
var LeaveCount = difference + 1;
           
if (stDate.getDay() == 0) {
               
LeaveCount = LeaveCount -
1;               
            }
  
         else
if (stDate.getDay() == 6) {
               
LeaveCount = LeaveCount - 1;
           
}
           
var loopDate = new
Date();
           
loopDate = stDate;
           
// Excluding Sat ,Sun in Selcted Dates
           
for (var i = 1;
i < difference + 1; i++) {
               
var NextDate = new
Date(loopDate.getYear(), loopDate.getMonth(), loopDate.getDate() +
1);               
                var Ndate = NextDate.getMonth() + 1 + "/" + NextDate.getDate() + "/" + NextDate.getYear();
    
           var NdateSplit = Ndate.split("/");
               
var NxtDate = new
Date(NdateSplit[2], NdateSplit[0] - 1, NdateSplit[1]);
               
loopDate = NxtDate;
                if (NxtDate.getDay() == 0) {
                   
LeaveCount = LeaveCount -
1;                  
                }
               
else if
(NxtDate.getDay() == 6) {
                   
LeaveCount = LeaveCount - 1;                  
                }
           
}            
            document.getElementById('<%=
txtTotalDays.ClientID%>').value
= LeaveCount;
        }
 
No comments:
Post a Comment