Stian Johansen Stian Johansen - 24 days ago 5
jQuery Question

JQuery DateTimePicker UI getting total days between two datetimepickers

i am trying to get the total days from the two customized DateTimePickers i've got.

I've tried this function:

function dateDifference() {
if($("#fradato").val()!='' && $("#fradato").val()!='') {
var diff = ($("#fradato").datepicker("getDate") - $("#tildato").datepicker("getDate")) / 1000 / 60 / 60 / 24;
$("#antalldager").val(diff)


The problem i've got is that wherever i try to call this function, the DateTimePicker stop working. So where/how should i call this function or is there a better way to do it?

I want to display the toal days inside of this text-box:

<div class="form-group">
<label class="control-label col-sm-1 col-sm-offset-3" for="antalldager">Antall dager:</label>
<div class="col-sm-2">
<input type="text" class="form-control" id="antalldager" disabled>




Here is my html:

<script>valgavdato() </script>
<div id="visdager" style="display: none;">
<label class="control-label col-sm-2 col-sm-offset-3" for="fradato">Book fra:</label>
<div class="container">
<div class="row">
<div class='col-sm-2'>
<div class="form-group">
<div class='input-group date'>
<input type="text" id="fradato" class="form-control"/>
<span class="input-group-addon">
<span class="glyphicon glyphicon-calendar" ></span>
</span>
</div>
</div>
</div>
</div>
</div>
<div id="vistildato" style="display: none;">
<label class="control-label col-sm-2 col-sm-offset-3" for="tildato">Book til:</label>
<div class="container">
<div class="row">
<div class='col-sm-2'>
<div class="form-group">
<div class='input-group date'>
<input type="text" id="tildato" class="form-control" />
<span class="input-group-addon">
<span class="glyphicon glyphicon-calendar"></span>
</span>
</div>
</div>
</div>
</div>
</div>





JS:

$( function valgavdato() {
var dateFormat = "mm/dd/yy",
to_MaxDate = 13; // From date + this = to maxDate

from = $( "#fradato" )
.datepicker({
minDate: '0+',
defaultDate: "+1w",
changeMonth: true,
numberOfMonths: 1

})
.on( "change", function() {
var PickedDate = getDate( this );
// See that date is in UTC format.
console.log( "From DatePicker: "+JSON.stringify(PickedDate) );

// Process the picked date.
var tempDay = PickedDate.getDate() + to_MaxDate; // Add a number of days to the picked date.
var tempMonth = PickedDate.getMonth() + 1; // Because months are zero based.
var tempYear = PickedDate.getYear() + 1900; // Because years are 1900 based
console.log( "Temp date: "+ tempYear+"/"+tempMonth+"/"+tempDay +" --- It may look impossible... But Date() handles it.");

// Create a date object in a UTC format.
var newMaxDate = new Date(Date.UTC(tempYear, tempMonth-1, tempDay, 0, 0, 0));
console.log( "New max date: : "+ JSON.stringify(newMaxDate) );

// Set the minDate ans maxDate options.
to.datepicker( "option", {"minDate": PickedDate, "maxDate": newMaxDate});
}),
to = $( "#tildato" ).datepicker({
maxDate: '14+',
defaultDate: "+1w",
changeMonth: true,
numberOfMonths: 1
})
.on( "change", function() {
from.datepicker( "option", "maxDate", getDate( this ) );
});

function getDate( element ) {
var date;
try {
date = $.datepicker.parseDate( dateFormat, element.value );
} catch( error ) {
date = null;
}
return date;
}
} );

function dateDifference() {
if($("#fradato").val()!='' && $("#fradato").val()!='') {
var diff = ($("#fradato").datepicker("getDate") - $("#tildato").datepicker("getDate")) / 1000 / 60 / 60 / 24;
$("#antalldager").val(diff)
}
}

Answer

I think @JanisP suggest is good. You can also make a lightweight function like:

function dateDifference(start, end) {
  // Assume Start and End string format: dd/mm/yyyy
  var d1 = new Date(start);
  var d2 = new Date(end);
  // d2 - d1 gives result in milliseconds
  // calculate number of days by Math.abs((d2-d1)/86400000, as 24*3600*1000 = 86400000
  return Math.abs((d2-d1)/86400000)
}

Found this here: jQuery UI Datepicker - Number of Days Between Dates

Update

From the jQuery UI Datepicker Select a Date Range example, I created this working example: https://jsfiddle.net/Twisty/r8wx6afk/

It calculates the number of days only when both fields have a date during the change event.

Comments