How do I specify a datetime format when reading a .csv/Excel file?

22 views (last 30 days)
I would like to change the datetime format of dates read in from .csv files. How do I do that?

Accepted Answer

MathWorks Support Team
MathWorks Support Team on 1 Apr 2020
You can use 'setvaropts' to change the format of datetime variables. For example:
opts = detectImportOptions('example.csv');
opts = opts.setvaropts('myVariable','InputFormat','M/d/yyyy','DateTimeFormat','dd-MMM-yyyy');
t = readtable('example.csv',opts)
% 'example.csv' contains the column:
% myVariable
% 1/31/2020
'InputFormat' tells 'readtable' how to interpret the values in the file, while 'DateTimeFormat' tells MATLAB how to display the datetimes once they are in MATLAB.
For more information, refer to the "Import Date and Time Data" section on the following documentation page:

More Answers (0)

Community Treasure Hunt

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

Start Hunting!