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

3 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)

Categories

Find more on Dates and Time in Help Center and File Exchange

Products


Release

R2019b

Community Treasure Hunt

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

Start Hunting!