using readtable to convert columns containing dates to datetime

2 views (last 30 days)
I need to convert columns containing dates in the xlsx file to datetime format using readtable()
This is what have so far, but there is an error.
T = readtable('US_Presidents.xlsx'); %Create a table by reading from a file.
datetime(US_Presidents.BirthDate,'InputFormat', 'yyyy-MM-dd');

Answers (1)

Akira Agata
Akira Agata on 4 Nov 2020
Like this?
T = readtable('US_Presidents.xlsx','PreserveVariableNames',true);
T.("Birth Date") = datetime(T.("Birth Date"));
T.("Death Date") = datetime(T.("Death Date"));
T.("Date took office") = datetime(T.("Date took office"));
T.("Date left Office") = datetime(T.("Date left Office"));

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!