Convert Text into Date Format
3 次查看(过去 30 天)
显示 更早的评论
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?
1 个评论
Allen
2021-5-26
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
回答(3 个)
dpb
2021-3-1
>> 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.
0 个评论
Allen
2021-3-1
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')
0 个评论
Steven Lord
2021-3-1
If you have a number:
x = 196307;
datetime(100*x+1, 'ConvertFrom', 'yyyymmdd')
If you have text:
y = string(x);
datetime(y, 'InputFormat', 'yyyyMM')
1 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Language Support 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!