creating the same format for the dates

Question

tzaloupas 2013-2-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/60840-creating-the-same-format-for-the-dates

采纳的回答： Miroslav Balda

在 MATLAB Online 中打开

Dear all,

I have this date issue

dates= {

    '11/2008'
    '12/2008'
    '1/02/2010'
    '2/02/2010'
     '12/03/2010'
    }

where 11/2008 is mm/yyyy As you can see the format of the dates is not the same

I would like to have either the format dd/mm/yyyy or the format mm/yy

Is there any way of doing that in matlab?

The full date vector is 40000 by 1 thanks

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Miroslav Balda 2013-2-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/60840-creating-the-same-format-for-the-dates#answer_73545

在 MATLAB Online 中打开

The following code fulfils the requirement, should the format of input dates be dd/mm/yyyy or mm/yyyy:

dates= {
    '11/2008'
    '12/2008'
    '1/02/2010'
    '2/02/2010'
     '12/03/2010'
    }
for k=1:length(dates)
%    I = find(cell2mat(d(k))=='/');
    I = find(dates{k}=='/');
    if length(I)==1
        d = ['22/' dates{k}];
    else
        d = dates{k};
    end
    c=datevec(d,'dd/mm/yyyy');
    dates{k} = sprintf('%02d/%02d', c(2), c(1)-2000);
end
dates