creating the same format for the dates

2 次查看(过去 30 天)
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

采纳的回答

Miroslav Balda
Miroslav Balda 2013-2-2
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

更多回答(0 个)

类别

Help CenterFile 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