MATLAB Answers

How to convert a string into a date or datenum?

1 view (last 30 days)
Bruno Carvalho
Bruno Carvalho on 17 Jun 2021
Commented: Stephen Cobeldick on 18 Jun 2021
I have a column, about [4000 x 1] with the format 'yyyymmddHH'. Yes, all the numbers are together.
And i need to get a date, or a datenum from that, but i cant, since functions like datetime need the numbers separated.
Anyone know how to get arround this?
Thank you.

Answers (1)

Stephen Cobeldick
Stephen Cobeldick on 17 Jun 2021
Edited: Stephen Cobeldick on 17 Jun 2021
"... but i cant, since functions like datetime need the numbers separated."
I don't see that restriction mentioned anywhere in the DATETIME documentation.
S = ["2021061701";"2021010100";"1913061423"]
S = 3×1 string array
"2021061701" "2021010100" "1913061423"
D = datetime(S, 'InputFormat','yyyyMMddHH')
D = 3×1 datetime array
17-Jun-2021 01:00:00 01-Jan-2021 00:00:00 14-Jun-1913 23:00:00
  6 Comments
Stephen Cobeldick
Stephen Cobeldick on 18 Jun 2021
@Bruno Carvalho: you can accept this answer, if one of the comments includes the solution.

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!