Difference (in days) between two days in yyyy-mm-dd format?

Question

Sorry if this has been asked before, but I haven't been able to find anything. Here's essentially what I'm trying to do:

new Date(response.departureDate).getTime() - new Date(response.arrivalDate).getTime()

I need to calculate the total number of days (will always be a whole integer) between an arrival and departure date. These dates are strings, structured as 'YYYY-MM-DD'.

How do I go about this?

You have to use moment js its better way to solve your questions — Bhadresh Shiroya, Mar 14 '16 at 12:18

score 1 · Answer 1 · edited Mar 14 '16 at 12:22

1

You can use regexp OR a much simpler approach would be to become familiar with MomentJS API that lets you deal with dates in JS very smoothly (works in Node and browser)

http://momentjs.com/

It does add another tool to your toolbox, but as soon as you are manipulating dates, it is definetely worth it IMHO.

Way to go with MomentJS :

var depDate = moment(response.departureDate);
var arrDate = moment(response.arrivalDate);
var nbDays = depDate.diff(arrDate, 'days');

edited Mar 14 '16 at 12:22

Praveen Kumar Purushothaman

164,888
24
203
252

answered Mar 14 '16 at 12:18

kartsims

1,001
9
16

It is better to add some code. Right now it is a link only answer and links may rot. – Praveen Kumar Purushothaman Mar 14 '16 at 12:20
Is this better now ? – kartsims Mar 14 '16 at 12:22
Now better... `:)` – Praveen Kumar Purushothaman Mar 14 '16 at 12:22

score 1 · Answer 2 · edited May 23 '17 at 11:50

1

Look at the Miles' answer here Just change it to:

function parseDate(str) {
var mdy = str.split('-')
return new Date(mdy[2], mdy[0]-1, mdy[1]);
}

function daydiff(first, second) {
    return Math.round((second-first)/(1000*60*60*24));
}

and use:

daydiff(parseDate(response.departureDate), parseDate(response.arrivalDate));

edited May 23 '17 at 11:50

Community

1
1

answered Mar 14 '16 at 12:25

Cem Şengezer

213
1
12

score 0 · Answer 3 · answered Mar 14 '16 at 12:15

0

You can use RegEx to change them.

new Date(response.departureDate.replace(/-/g, "/")).getTime()
    - new Date(response.arrivalDate.replace(/-/g, "/")).getTime()

So the RegEx .replace(/-/g, "/") will replace all the - to /, and JavaScript will be able to read it right.

answered Mar 14 '16 at 12:15

Praveen Kumar Purushothaman

164,888
24
203
252

Okay, but the difference is something like `86400000`. How do I convert a date reference like this into days, Math.ceil? – j_d Mar 14 '16 at 14:18
@JohnDoe `86400000` milliseconds = `/1000` = `86400` seconds and then `/(60 * 60 * 24)` Days... Will be 1 day. Ultimately you need to do: `date/(60 * 60 * 24 * 1000)` – Praveen Kumar Purushothaman Mar 14 '16 at 14:19
NO, do not parse strings with the Date constructor (or Date.parse), it is very unreliable. Manually parse Date strings (2 lines of code or use a library). – RobG Mar 15 '16 at 03:04
@RobG Do you have a better suggestion? `:)` – Praveen Kumar Purushothaman Mar 15 '16 at 09:06
Yes, the string can be safely and consistently parsed with a 2 line function, e.g. the answers [*here*](http://stackoverflow.com/questions/15517024/how-to-assume-local-time-zone-when-parsing-iso-8601-date-string). – RobG Mar 15 '16 at 09:25
@RobG Thanks. `:)` – Praveen Kumar Purushothaman Mar 15 '16 at 09:25

score 0 · Answer 4 · answered Mar 14 '16 at 12:21

I hope this example help for you

Apart from .diff(), you could also use moment durations: http://momentjs.com/docs/#/durations/

Example Fiddle: https://jsfiddle.net/abhitalks/md4jte5d/

Example Snippet:

$("#btn").on('click', function(e) {
    var fromDate = $('#fromDate').val(), 
        toDate = $('#toDate').val(), 
        from, to, druation;

    from = moment(fromDate, 'YYYY-MM-DD'); // format in which you have the date
    to = moment(toDate, 'YYYY-MM-DD');     // format in which you have the date

    /* using duration */
    duration = moment.duration(to.diff(from)).days(); // you may use duration

    /* using diff */
    //duration = to.diff(from, 'days')     // alternatively you may use diff

    /* show the result */
    $('#result').text(duration + ' days');

});
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.11.1/moment.min.js"></script>
From: <input id="fromDate" type='date' />
To: <input id="toDate" type='date' />&nbsp;&nbsp;
<button id="btn">Submit</button><hr />
<p id="result"></p>

score 0 · Answer 5 · answered Mar 14 '16 at 12:24

0

You can use something like this

function countDays(date1, date2)
{
    var one_day=1000*60*60*24;
    return Math.ceil((date1.getTime()- date2.getTime()) /one_day);
}

countDays(new Date(response.departureDate), new Date(response.arrivalDate));

answered Mar 14 '16 at 12:24

S. Nadezhnyy

582
2
6

NO, do not parse strings with the Date constructor (or Date.parse), it is very unreliable. Manually parse Date strings (2 lines of code or use a library). – RobG Mar 15 '16 at 03:05
I think that depends on if you can trust response : looks like it is OK for John Doe, so I don't mind ) – S. Nadezhnyy Mar 15 '16 at 08:19
The OP is asking for advice. The format 'YYYY-MM-DD' (ISO 8601 date without timezone) will be parsed by ECMAScript 2015 compliant browsers as UTC, which will surprise those expecting it to be parsed as local. It will not be parsed by IE 8, which is still has about 8% usage (which is more than all versions of desktop Safari combined). Certain versions of some browsers will parse it as local. So even if the format is guaranteed, appropriate parsing isn't. – RobG Mar 15 '16 at 08:38

Difference (in days) between two days in yyyy-mm-dd format?

5 Answers5