Year conversion on figure wrong

2019 6 29
1 个回答
更新时间：2019 6 29
5 次查看（30 天）

0 个投票

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

0 个投票

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更早的评论 隐藏 2更早的评论

Benjamin Cowen
Benjamin Cowen 2019-6-29
how do i convert it to matlab?
Walter Roberson
Walter Roberson 2019-6-29
datetime 'convertfrom' 'excel'
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.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by