how to convert yymmdd to dd/mm/yyyy

Hi

Does anyone know how to convert yymmdd to dd/mm/yyyy? I have dates is given in the yymmdd format, such as 750525,780215,.....which mean year 1975, month-5, day-25 or year 1978, month-2,day-15. I wanted to convert the date in the form dd/mm/yyyy which is as 25/05/1975, 15/02/1978.

How I can do it?

Thanks a lot!

Answer 1

[Jos (10584)]

A = {'750525','780215'}
B = cellstr(datestr(datenum(A,'yymmdd'),'dd/mm/yyyy'))

[davit petraasya]

Thanks Jos for your answer. When I run it I am getting error message saying:

The input to DATENUM was not an array of strings. (I have date is given in excel as 750525,780215,... in my colomn) What would be problem?

[Jos (10584)]

How do you get them into matlab? You should convert them first to a cell array of strings for datenum to work properly.

[davit petraasya]

My matlab reading dates 750525,780215,... as numeric. I think Matlab understanding dates as numbers

[Jos (10584)]

A0 = [750525, 780215] A = arrayfun(@(x) sprintf('%06d',x), A0, 'un', 0) % convert to cell array of strings

[davit petraasya]

This is great Jos, it works perfectly. Thank you a lot!

Answer 2

[Steven Lord]

Use the 'ConvertFrom' option with datetime to create a datetime object representing your date.

x = 19990511;
D = datetime(x, 'ConvertFrom', 'yyyymmdd')

[davit petraasya]

Thanks Steven for your concern.