converting number to date number

48 views (last 30 days)
I have a column of dates that are number (double format) such as 19940127 how can i convert it to matlab numeric date that corresponds to 1994/01/27?

Accepted Answer

Star Strider
Star Strider on 1 Oct 2016
Edited: Star Strider on 1 Oct 2016
One approach:
dd = 19940127;
out = datestr(datenum(num2str(dd, '%d'), 'yyyymmdd'), 'yyyy/mm/dd')
out =
1994/01/27
To get the date number, just use part of that:
out_dn = datenum(num2str(dd, '%d'), 'yyyymmdd')
EDIT Added ‘out_dn’.

More Answers (1)

Steven Lord
Steven Lord on 1 Oct 2016
Use the datetime function with the 'ConvertFrom', 'yyyymmdd' option.

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!