CSV Input date format

Hello,

I'm trying to import a date string such as '01/10/2018 16:09:26,934';

However when doing the following:

DateString = '01/10/2018 16:09:26,934';
formatIn =   'MM/dd/yyyy HH:mm:SS,sss';
datetime(DateString,'InputFormat',formatIn)

It returns the following error:

Unable to parse '01/10/2018 16:09:26,934' as a date/time using the format 'MM/dd/yyyy HH:mm:SS,sss'.

Any ideas?

[Jan]

Whenever you mention, that you get an error, post a copy of the complete message. It is easier to fix a problem than to guess the error.

[Rodrigo Alvarez Hernandez]

Sorry, edited question

Answer 1

[Jan]

The seconds are lower case 'ss', the fractional seconds uppercase 'SSS':

formatIn =   'MM/dd/yyyy HH:mm:ss,SSS'

See the documentation of datetime: https://www.mathworks.com/help/matlab/ref/datetime.html#buhzxmk-1-Format

[Rodrigo Alvarez Hernandez]

uhgh, I feel so stupid, ive been looking that page wondering what was wrong...

Kudos!

[Jan]

You are welcome, Rodrigo. It is a well known fact, that the eyes of a programmer are blind for the problems, which are solved inside the brain already. Then it is useful to ask another person, who find the problem on the first view. I know this from my own experiences also :-)