from cell to datetime

A silly question: where is the error here below?

a={'Monday, 03-Jul-2017 15:00:00'};
datetime(a,'InputFormat','dddd, dd-MMM-yyyy HH:mm:ss')

Error using datetime
Unable to convert 'Monday, 03-Jul-2017 15:00:00' to datetime using the format 'dddd, dd-MMM-yyyy HH:mm:ss'. If the date/time text contains day, month, or time zone names in a language foreign to the 'en_US' locale, those might not be recognized. You can specify a different locale using the 'Locale' parameter.

Answer 1

[Star Strider]

Use 'eeee' for the full name of the day —

a={'Monday, 03-Jul-2017 15:00:00'};
datetime(a,'InputFormat','eeee, dd-MMM-yyyy HH:mm:ss', 'Format','eeee, dd-MMM-yyyy HH:mm:ss')

ans = datetime
   Monday, 03-Jul-2017 15:00:00

(Added: optional 'Format' string.)

.

[Sim]

thanks a lot @Star Strider!

I did not know about "eeee"... thanks!

[Star Strider]

As always, my pleasure!