Year conversion on figure wrong

2 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?

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
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

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!