MATLAB Answers

Year conversion on figure wrong

7 views (last 30 days)
Benjamin Cowen
Benjamin Cowen on 29 Jun 2019
Commented: Walter Roberson on 29 Jun 2019
If I read in a date, say 7/15/2017, but I read it in as 42931.00, when in MATLAB when I do this:
datetick('x', 'yyyy');
I get the year as 0117 instead of 2017?

  0 Comments

Sign in to comment.

Answers (1)

per isakson
per isakson on 29 Jun 2019
Edited: per isakson on 29 Jun 2019
That's most likely because 42931.00 is an Excel date number, not a Matlab date number.
MATLAB date numbers start with 1 = January 1, 0000 A.D., hence there is a difference of 693960 relative to the 1900 date system

  4 Comments

Show 1 older comment
Walter Roberson
Walter Roberson on 29 Jun 2019
datetime 'convertfrom' 'excel'
Benjamin Cowen
Benjamin Cowen on 29 Jun 2019
when i do this:
t = datetime(date,'ConvertFrom','excel');
why does the x axis only show the begin and end date for this:
datetick('x', 'yyyy');
Walter Roberson
Walter Roberson on 29 Jun 2019
date is a function that returns a single character vector, that datetime then converts into a single datetime object. If you plot with that as your only data point then MATLAB invents start and end times.

Sign in to comment.

Tags