Check for missing dates in date array in Matlab

Question

I have an array of, say, end of month datenum in Matlab. I am looking for a function to check if the dates are consecutive. Consider the following array of dates:

Dates = [datenum(2000,1:10,eomday(2000,1:10)),datenum(2000,12,31),datenum(2001,1:2,eomday(2001,1:2))];

datestr(Dates)

ans =

31-Jan-2000
29-Feb-2000
31-Mar-2000
30-Apr-2000
31-May-2000
30-Jun-2000
31-Jul-2000
31-Aug-2000
30-Sep-2000
31-Oct-2000
31-Dec-2000
31-Jan-2001
28-Feb-2001

where the 30-Nov-2000 is missing. I would like a functionality to identify that 31-Jan-2000 to 31-Oct-2000 are consecutive, that 30-Nov-2000 is missing, and that 31-Dec-2000 to 28-Feb-2001 are consecutive.

Any ideas??

use datevec and check the months.

Shai
– Shai

2015-04-29 08:28:32 +00:00
Commented Apr 29, 2015 at 8:28 — Shai
– Shai, Commented Apr 29, 2015 at 8:28

xenoclast · Accepted Answer · 2015-04-29 08:28:40Z

2

You can convert your dates to serial numbers using datenum, then you can do a diff on it and find values greater than the datenum of your desired interval.

answered Apr 29, 2015 at 8:28

xenoclast

1,63515 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Check for missing dates in date array in Matlab

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related