Read mm/dd/yy in Matlab

9 次查看（过去 30 天）
Theodore
Theodore 2013-7-2
评论： Walter Roberson 2016-6-1
Hello!
I've been reading in an .xls file (although I'd like it to be .csv if that were possible for Matlab to read dates from) and am having trouble with it. They currently are set up in mm/dd/yy format and when read into matlab convert to a multiple digit code that I can't seem to translate back to original dates.
The first date listed is 6/1/90 and converts to the code 33025. Any ideas? Thanks!
  2 个评论
Nelson Mok
Nelson Mok 2016-6-1
Hope this help.
clear; t = readtable('ABC.xls'); datestr(x2mdate(t.Date),'mm/dd/yy')
Walter Roberson
Walter Roberson 2016-6-1
readtable() did not exist at the time the original question was posted.
These days you would use
t = readtable('ABC.xls');
t.Date = datetime(t.Date, 'ConvertFrom', 'Excel', 'Format', 'MM/dd/yy');

请先登录，再进行评论。

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

采纳的回答

Evan
Evan 2013-7-2
编辑：Evan 2013-7-2
That data you are reading is being brought in as a date number instead of a date string. The following function allows you to convert date numbers to date strings:
help datestr
You can specify the style that you want datestr to return like so:
d = 33025;
ds = datestr(d,2)
In this case, the 2 argument causes datestr to return in "mm/dd/yyy" format. The documentation for datestr tells what styles are available.
  2 个评论
Theodore
Theodore 2013-7-2
Worked PERFECTLY! Thanks so much!
Evan
Evan 2013-7-2
Great! You're welcome!

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by