How to get numbers of Month based on two dates and calculate average amount from total amount ?
Get the number of month from given date. and Get the average amount from two dates and total amount. Here is the code which i used to solved this problem.
<script type="text/javascript">
$(document).ready(function(){
$("#frmrepaymentID").validate();
});
$('#repaymentDate_ID').datepicker({
showButtonPanel: true,
changeMonth:true,
changeYear:true,
dateFormat: 'yy-mm-dd',
onClose: function(dateText, inst) {
if($(this).val()) {
var fromDate = $("#repaymentFromID").val();
var toDate = $(this).val();
var format = 'yy/mm/dd';
var from_data = fromDate.split("-",3);
var to_data = toDate.split("-",3);
var getMonthNumber= monthsBetween(new Date(from_data[0],from_data[1],from_data[2]),new Date(to_data[0],to_data[1],to_data[2]));
var amount = $("#repayAmount").val();
var averageAmount;
if(getMonthNumber) {
averageAmount =amount/getMonthNumber;
document.getElementById("avgAmount").value = averageAmount;
}
}
}
});
function monthsBetween(date1, date2) {
var months = date2.getFullYear() * 12 + date2.getMonth() - date1.getFullYear() * 12 - date1.getMonth();
if (date2.getDate() < date1.getDate()) {
months--;
}
return months;
}
</script>
<input type="text" name="repayment[repayment_amount]" id="repayAmount" class="required">
<input type="text" name="repayment[from_date]" id="repaymentFromID" class="frm_Date datepicker">
<input type="text" name="repayment[to_date]" id="repaymentDate_ID" class="to_Date datepicker" >
<input type="text" name="repayment[average_amount]" id="avgAmount" class="required">