How to convert this string to a datetime?

5 views (last 30 days)
Hi! Unfortunately, MATLAB is not allowing me to convert this series of strings of date to a datetime series. Can anyone please help?
D = ['2003/06/24'
'2003/07/10'
'2003/07/10'
'2003/07/10'
'2003/07/18'
'2003/07/26'
'2003/08/03'
'2003/08/11'
'2003/08/19'
'2003/08/27'];
Any feedback will be greatly appreciated!
  2 Comments
Steven Lord
Steven Lord on 14 Dec 2022
Can you show the command you're using to try to perform this conversion and describe what "not allowing" means in this context?
  • Do you receive warning and/or error messages? If so the full and exact text of those messages (all the text displayed in orange and/or red in the Command Window) may be useful in determining what's going on and how to avoid the warning and/or error.
  • Does it do something different than what you expected? If so, what did it do and what did you expect it to do?
  • Did MATLAB crash? If so please send the crash log file (with a description of what you were running or doing in MATLAB when the crash occured) to Technical Support so we can investigate.
Ashfaq Ahmed
Ashfaq Ahmed on 14 Dec 2022
Edited: Ashfaq Ahmed on 14 Dec 2022
Thank you so much! It works. The reason why it wasn't working the previous time is -- all the strings I showed here were a column of a table. So, I first used the function table2array, and then used Stephen's code!

Sign in to comment.

Accepted Answer

Stephen23
Stephen23 on 14 Dec 2022
D = ['2003/06/24'
'2003/07/10'
'2003/07/10'
'2003/07/10'
'2003/07/18'
'2003/07/26'
'2003/08/03'
'2003/08/11'
'2003/08/19'
'2003/08/27'];
T = datetime(D, 'inputformat','u/M/d')
T = 10×1 datetime array
24-Jun-2003 10-Jul-2003 10-Jul-2003 10-Jul-2003 18-Jul-2003 26-Jul-2003 03-Aug-2003 11-Aug-2003 19-Aug-2003 27-Aug-2003
  2 Comments
Ashfaq Ahmed
Ashfaq Ahmed on 14 Dec 2022
Thank you so much! It works. The reason why it wasn't working the previous time is -- all the strings I showed here were a column of a table. So, I first used the function table2array, and then used your code!
Stephen23
Stephen23 on 14 Dec 2022
"So, I first used the function table2array.."
It is simpler and more efficient to use basic indexing:

Sign in to comment.

More Answers (0)

Categories

Find more on Data Type Conversion in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!