Date format 03mar2013

Hi,
I hope all is well. How can I read dates such as 03mar2013 and transform them to matlab datenumber? I hav ethese dates in excel and every import date option that i used resulted nans.

4 Comments

Are you sure you need datenum? We recommend datetime instead.
Wesso
Wesso on 13 May 2019
the important thing is so bring it to matlab while avoiding NaNs. Not sure though why datetime is better than datenum (I am used to work with datenum) . Nevertheless, I think datetime will work as well.
datetime('03mar2013', 'inputformat', 'ddMMMyyyy')
Wesso
Wesso on 15 May 2019
thanks. it works perfectly well

Answers (0)

This question is closed.

Asked:

on 13 May 2019

Closed:

on 20 Aug 2021

Community Treasure Hunt

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

Start Hunting!