Convert Text into Date Format

Hi, I struggle a lot!

I want to convert the text 196307 into a date format that MATLAB recognizes as "July 1963".

How can I do that?

[Allen]

JBA,

If any of the suggested solutions were able to solve your problem please do not forget to accept the answer. This will help other people that are looking for a similar answer know what works. Otherwise perhaps you can include what problems you may still be running into with the provided solutions.

Thanks,

Allen

Answer 1

[dpb]

>> datetime('196307','InputFormat','yyyyMM')
ans = 
  datetime
   01-Jul-1963
>> 

or

>> datetime([floor(196307/100) 196307-floor(196307/100)*100 1])
ans = 
  datetime
   01-Jul-1963
>> 

Your choice depending upon whether you're starting with a string or a number.

Answer 2

[Allen]

Try the following:

% Code works with either a string or numerical input
str = '196307';
datestr(datenum(str,'yyyymm'),'mmmm yyyy')

num = 196307;
datestr(datenum(num,'yyyymm'),'mmmm yyyy')

Answer 3

[Steven Lord]

If you have a number:

x = 196307;
datetime(100*x+1, 'ConvertFrom', 'yyyymmdd')

ans = datetime
   01-Jul-1963

If you have text:

y = string(x);
datetime(y, 'InputFormat', 'yyyyMM')

ans = datetime
   01-Jul-1963

[dpb]

datetime(100*x+1, 'ConvertFrom', 'yyyymmdd')

Clever! +1