how to create date variable or column

Question

MAHMOUD ALZIOUD 2019-5-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/461392-how-to-create-date-variable-or-column

评论： Star Strider 2019-5-10

Dear All, I have numeric matrix of 3 columns and 100 rows, the 1st column is A and represents day number from 1 to 30, the 2nd column is B and represents month number from 1 to 12, the 3rd one is the year, how can I please create 4th column for the date in the format mm/dd/year? by combining the 3 columns. And then add this column with this format to the matrix as a 4th column. thank you

4 个评论
显示 2更早的评论隐藏 2更早的评论

James Tursa 2019-5-10

Readers are going to be reluctant to download an Excel spreadsheet. Can you provide what you have on the MATLAB side? Do you need help in loading the spreadsheet into MATLAB?

MAHMOUD ALZIOUD 2019-5-10

What do you mean by spreadsheet? I have the data in a matrix in the workspace

请先登录，再进行评论。

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

Answer 1

Star Strider 2019-5-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/461392-how-to-create-date-variable-or-column#answer_374464

在 MATLAB Online 中打开

Your data have a two-digit year. Assuming ‘10’ means ‘2010’, try this:

D = xlsread('data.xlsx');
Col4 = datetime(fliplr(D)+[2000 0 0], 'Format','MM/dd/yyyy');

producing:

Col4 = 
  22×1 datetime array
   01/01/2010
   01/01/2010
   01/01/2010
   01/01/2010
      . . .

Using a table:

      Tbl = table(D(:,1),D(:,2),D(:,3),Col4, 'VariableNames',{'Day','Month','Year','All'})

produces:

Tbl =
  22×4 table
    Day    Month    Year       All    
    ___    _____    ____    __________
     1       1       10     01/01/2010
     1       1       10     01/01/2010
     1       1       10     01/01/2010
     1       1       10     01/01/2010
               . . .