MATLAB: How to import dates

datesimporting excel data

I have a database in excel like numbers, text and dates and I am not able to import the dates correctly. I'm using the following code
path(path, 'C:\Users\vinic\thesis\Matlab')
[data, textdata, rawdata]=xlsread('Teste',1);
Viewing rawdata the dates were imported as follows. However, the first date didn’t come just the day
'Time Stamp'
'01/06/2017'
'01/06/2017 00:10:00'
'01/06/2017 00:20:00'
'01/06/2017 00:30:00'
'01/06/2017 00:40:00'
'01/06/2017 00:50:00'
'01/06/2017 01:00:00'
'01/06/2017 01:10:00'
'01/06/2017 01:20:00'
'01/06/2017 01:30:00'
How can solve this problem?
I need the first item to appear as follows
'01/06/2017 00:00:00'

Best Answer

  • If you are unfamiliar with readtable, start by using the import tool. It is on the toolstrip in the Home tab. This video from the Practical Data Science with MATLAB course can help. Once you have the datatypes and formatting set the way you want, import the data, covert the settings to code, or generate an import function for repeated use.