Import csv file with date and time in AM/PM format

Hi everyone! I want to import some dates into Matlab but I do not seem to get the right datetime format. Normally I use Matlab's Import tool, and specify a format for my dates. My problem now is that I have the dates in AM/PM format which I am not familiar with. I have browsed through some examples without any luck. My question is: what is the proper format in order to import these dates in a datetime array?

MM/dd/yyyy HH:mm:ss ??

Some dates:

    (...)
    3/13/2017 11:20:00 PM
    3/13/2017 11:30:00 PM
    3/13/2017 11:40:00 PM
    3/13/2017 11:50:00 PM
    3/14/2017 12:00:00 AM
    3/14/2017 12:10:00 AM
    3/14/2017 12:20:00 AM
    (...)

I would sincerely appreciate any help. Thanks in advance!

[Stephen23]

Is it possible to change the date format to something more sensible (and universal), e.g.:

https://en.wikipedia.org/wiki/ISO_8601

Answer 1

[per isakson]

Try this format

>> str =
3/13/2017 11:20:00 PM
>> cac = textscan( str, '%{MM/dd/yyyy hh:mm:ss a}D', 'Delimiter',',', 'Whitespace','' )
cac = 
    [03/13/2017 11:20:00 PM]

The problem seems to be to convince Matlab not to interpret the spaces as deliniters

[Adriel Perez Tellez]

Ah okej. Problem solved. Thanks!

[Laraib Imtiaz]

hey how?