I want to auto calculate number of days between dates picking from two textboxes using datepicker...i had tried but it showing NaN value..please reply asap

Question

0.00/5 (No votes)

See more:

JavaScript

<script type="text/javascript" src="js/jquery.ui.datepicker-tr.js"> </script>
<script type="text/javascript" src="js/jquery-1.7.1.min.js"></script>
<script type="text/javascript" src="js/jquery.flexslider-min.js"></script>

<script type="text/javascript" src="js/calendar1.js"></script>
<script type="text/javascript" src="js/Calendar2.js"></script>

<script type="text/javascript">
$(function () {
  $("#<%= TextBox1.ClientID %>").datepicker({ minDate: 0, maxDate: '+1Y+6M', onSelect: function (dateStr) {
    var min = $(this).datepicker('getDate'); // Get selected date
    $("#<%= TextBox2.ClientID %>").datepicker('option', 'minDate', min || '0'); // Set other min, default to today
  }});

  $("#<%= TextBox2.ClientID %>").datepicker({ minDate: '0', maxDate: '+1Y+6M', onSelect: function (dateStr) {
    var max = $(this).datepicker('getDate'); // Get selected date
    $('#datepicker').datepicker('option', 'maxDate', max || '+1Y+6M'); // Set other max, default to +18 months
    var start = $("#<%= TextBox1.ClientID %>").get();
    var end = $("#<%= TextBox2.ClientID %>").get();
    var diff = new Date(end - start);
    var days =Math.abs( diff / (1000 * 60 * 60 * 24));
    $("#<%= TextBox3.ClientID %>").val(days);
  }});
});
</script>

Posted 10-Aug-14 1:51am

Monika Rangta

Updated 10-Aug-14 6:09am

Kornfeld Eliyahu Peter

v4

Add a Solution

Comments

[no name] 10-Aug-14 8:16am

Looks more like javascript than C# to me. Not sure what it is that you would expect from dividing a Date object by an integer value would get you. See,
http://www.htmlgoodies.com/html5/javascript/calculating-the-difference-between-two-dates-in-javascript.html#fbid=AWychY-QSqg

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 10-Aug-14 8:38am

Debug and see where exactly you are getting the NAN error?

Kornfeld Eliyahu Peter 10-Aug-14 8:40am

I believe here: var days = Math.abs( diff / (1000 * 60 * 60 * 24));
diff is a JavaScipt Date object!

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 10-Aug-14 9:07am

See my answer. :)

Monika Rangta 10-Aug-14 8:48am

Well, I am new in javascript...
in TextBox3, it is showing NaN ..I think, There is problem in calculation.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 10-Aug-14 9:07am

Okay. Now see my answer. :)

2 solutions

Solution 1

The variable diff is a Date so you cannot divide it by a number. you need to use one of the getters to extract a time value, such as:

JavaScript

var days =Math.abs( diff.getMilliseconds() / (1000 * 60 * 60 * 24));

Posted 10-Aug-14 3:05am

Richard MacCutchan

Comments

Monika Rangta 10-Aug-14 9:10am

Thanks :)

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2014-08-10T03:06:00

Solution 2

I changed the code a little bit and now it is working.

JavaScript

var start = $("#TextBox1").datepicker("getDate");
var end = $("#TextBox2").datepicker("getDate");
var days = (end - start) / (1000 * 60 * 60 * 24);

Demo

[Demo] Calculate Day Difference by jQuery Datepicker[^]

Posted 10-Aug-14 3:06am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

Monika Rangta 10-Aug-14 9:10am

Thanks alot.. Its Working grt :)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 10-Aug-14 9:14am

Most welcome. Please accept the answer and upvote. :)