Year conversion on figure wrong

1 次查看（过去 30 天）
Benjamin Cowen
Benjamin Cowen 2019-6-29
评论： Walter Roberson 2019-6-29
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?

请先登录，再回答此问题。

回答（1 个）

per isakson
per isakson 2019-6-29
编辑：per isakson 2019-6-29
That's most likely because 42931.00 is an Excel date number, not a Matlab date number.
See Dates And Times In Excel. and https://se.mathworks.com/matlabcentral/answers/64198-matlab-datenum-to-excel-datetime#answer_75809
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 个评论
显示 2更早的评论
Benjamin Cowen
Benjamin Cowen 2019-6-29
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 2019-6-29
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.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by