create yyyymm variable from date

I have a date variable. I want to create yyyymm from the date variable. I can use the year function and the month function to extract year and month. I would like to know how one can create yyyymm variable.

3 个评论

When you say you have a "date variable", what format is it? Is it a datenumber? A datetime? Something else? Can you post an example of your data, either by posting some code, or uploading in a MAT file?
Thank you. It is datetime. It is like 1/1/2020. Want to extract just yyyymm out of it.
yyyymmdd=yyyymmdd(Date);
yyyymm=floor(yyyymmdd./100);

请先登录,再进行评论。

 采纳的回答

Try this:
dt = '1/1/2020';
Out = datetime(dt, 'InputFormat','MM/dd/yyyy', 'Format','yyyyMM')
producing:
Out =
datetime
202001
.

3 个评论

I should also have asked OP what format they wanted for the output, too. :-)
It's best to leave things as datetime format where possible, if you need to convert to string or character, then just add
string(Out)
or
char(Out)
to this solution.
Thank you. Let me work on it.
As always, my pleasure!

请先登录,再进行评论。

更多回答(0 个)

类别

帮助中心File Exchange 中查找有关 Dates and Time 的更多信息

产品

版本

R2020a

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by