Clear Filters
Clear Filters

Convert serial number dates to month and year

10 views (last 30 days)
I have a date (736473) that i want to convert to month and year. How do i go about doing that ?

Accepted Answer

Paolo
Paolo on 23 Jul 2018
Edited: Paolo on 23 Jul 2018
mydate = datetime(736473,'ConvertFrom','datenum','Format','yyyy-MM')
  5 Comments
Paolo
Paolo on 23 Jul 2018
Edited: Paolo on 23 Jul 2018
That's very true Walter, datenum is indeed redundant. I should probably get some sleep... I'll edit.

Sign in to comment.

More Answers (1)

Walter Roberson
Walter Roberson on 23 Jul 2018
dv = datevec(736473);
year = dv(:,1);
month = dv(:,2);
  1 Comment
Walter Roberson
Walter Roberson on 23 Jul 2018
If you want the result as a cell array of character vectors, then you can use
datestr(736473:736475,'yyyy-mm')
for example.
Note that for datestr(), the coding for month is lower-case m, but that for the newer datetime(), the coding for month is upper-case M.

Sign in to comment.

Categories

Find more on Dates and Time in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!