Coverting specific string containing date to datetime

2021 3 9
2 个回答
回答已采纳
更新时间：2021 3 9
3 次查看（30 天）

0 个投票

Dear all,
Let say I have a dataset with the variable 'Period', which want to convert to a datetime: 2012-12-01; 2013-03-01, 2013-06-01, ...
I know I must somehow extract year and quarter from the variable and create new datetime variable based on that, could you help me with the exact code?
Period
'2012_Q4'
'2013_Q1'
'2013_Q2'
'2013_Q3'
'2013_Q4'
'2014_Q1'
'2014_Q2'
'2014_Q3'
'2014_Q4'

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

 采纳的回答

Stephen23
Stephen23 2021-3-9
编辑：Stephen23 2021-3-9
Ran in:

0 个投票

Ran in:
C = {...
'2012_Q4'
'2013_Q1'
'2013_Q2'
'2013_Q3'
'2013_Q4'
'2014_Q1'
'2014_Q2'
'2014_Q3'
'2014_Q4'};
T = datetime(C, 'InputFormat','yyyy_QQQ', 'Format','yyyy-MM-dd');
T = T + calmonths(2)
T = 9×1 datetime array
2012-12-01 2013-03-01 2013-06-01 2013-09-01 2013-12-01 2014-03-01 2014-06-01 2014-09-01 2014-12-01

更多回答（1 个）

0 个投票

Dear Cris and Stephen,
Thank you for your suggestions.
Kind regards,
JP

类别

在 帮助中心 和 File 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