Effacer les filtres
Effacer les filtres

Matlab - how to convert date format in example provided

2 vues (au cours des 30 derniers jours)
olayinka ola
olayinka ola le 31 Oct 2020
Commenté : Ameer Hamza le 31 Oct 2020
In my code below I am unable to convert the date format in column 1 from dd/MM/yyyy to MM-dd-yyyy. How do I configure it correctly to stop seeing this error??
>> T = readtable("IGEv3.xlsx");
>> tday=T{2:end, 1};
>> tday=datestr(datenum(tday, 'dd-MM-yyyy'), 'MM-dd-yyyy')
Error using datetime/datenum
Too many input arguments.

Réponse acceptée

Ameer Hamza
Ameer Hamza le 31 Oct 2020
Modifié(e) : Ameer Hamza le 31 Oct 2020
You just need to change the format property of the datetime object
T = readtable("IGEv3.xlsx");
tday = T{2:end, 1};
tday.Format = 'MMM-dd-yyyy';
  2 commentaires
olayinka ola
olayinka ola le 31 Oct 2020
Brilliant thanks, so simple!
Ameer Hamza
Ameer Hamza le 31 Oct 2020
I am glad to be of help!

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Financial Toolbox dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by