datestr producing incorrect dates

4 次查看（过去 30 天）
Cary
Cary 2014-6-28
评论： per isakson 2014-6-28
Hello everyone,
I am testing some historical data, and and the raw dates import as serialized dates. So when I convert these dates into strings in the 'yyyymmdd' format, I would expect to see the following: 39400 (serial date) converts into 20071114 (November 14, 2007). However, when I use datestr on 39400 I get 01071115. In other words, the year (2007) and the day(14th) are incorrect. Am I missing something? Thanks for reading.

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

回答（2 个）

per isakson
per isakson 2014-6-28
编辑：per isakson 2014-6-28
"39400" is an "Excel serial date number".
Matlab: A serial date number represents the whole and fractional number of days from a fixed, preset date (January 0, 0000).
See: Represent Dates and Times in MATLAB
Try
>> datenum( '20071114', 'yyyymmdd' )
ans =
733360
.
There is a function in the Financial Toolbox, x2mdate, Excel serial date number to MATLAB serial date number. See that documentation and write your own function.
Cary
Cary 2014-6-28
编辑：Cary 2014-6-28
Thank you. How can I prevent the dates from being imported as excel serial numbers (I understand I can use x2mdate if this is not possible)?
  1 个评论
per isakson
per isakson 2014-6-28
AKAIK: One cannot prevent that and has to convert them in a second step. See my answer.

请先登录，再进行评论。

类别

在 Help Center 和 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