error xlsread import dates

1 view (last 30 days)
Matteo Pazzaglia
Matteo Pazzaglia on 10 Apr 2020
Answered: Rajani Mishra on 13 Apr 2020
Hi all,
I have a problem when I import dates from an xls file. It contains a column of dates, one of price, dates, price and so on. If I open the file from the Matlab folder, dates are "dd/MM/yyyy".
[price, dates]=xlsread(filename);
With this command I found a problem in the matrix dates in fact it gives me for example "monday-03-08-2010" instead of the "canonical" format "dd/mm/yyyy" and I don't know why. I've already tried with xlsread(filename, 'mm/dd/yyyy') but without solution. Can someone help me?
Thanks a lot
P.s. Matlab version 2019

Accepted Answer

Rajani Mishra
Rajani Mishra on 13 Apr 2020

More Answers (0)

Community Treasure Hunt

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

Start Hunting!

Translated by