Convert char to date

31 visualizaciones (últimos 30 días)
BA
BA el 17 de Jul. de 2022
Comentada: BA el 17 de Jul. de 2022
Basically, I have a table with dates that are currently char's and I want to convert them into datetime format. This is how the dates are now:
'2/4/22'
'2/5/22'
'2/6/22'
The problem is that these dates conflict with another dataset where the dates are like this:
2/4/22
2/5/22
2/6/22
I'm trying to make the dates appear the same for both tables and this was the command I ran:
Data.StudyDate_converted = cellfun(@(x) datetime(x), Data.StudyDate, 'UniformOutput', false);
This isn't doing the trick. The new column that the table creates in the table shows a 1x1 date time in each cell and when you click on it, the date reads as 04-Feb-0022
If someone knows a fix, please let me know. I attached the dataset that I want to convert from a char to datetime to this post in case its needed. The specific variable I want to convert from char to datetime is "StudyDate".
Thanks in advance

Respuesta aceptada

Walter Roberson
Walter Roberson el 17 de Jul. de 2022
filename = 'https://www.mathworks.com/matlabcentral/answers/uploaded_files/1067985/Book5.xlsx';
Data = readtable(filename);
Data.StudyDate_converted = datetime(Data.StudyDate, 'Format', 'M/d/yy');
Data(1:3,:)
ans = 3×9 table
StartDate EndDate SubID Group StudyDay MetricWireID Protocol StudyDate StudyDate_converted ___________ ___________ _________ _______ ________ _____________________________ ________ ____________ ___________________ 09-Mar-2022 06-Apr-2022 2.176e+07 {'OUD'} 1 {'7sadd0a7sd9a8sd9a8d0as8da'} 41 {'03/09/22'} 3/9/22 09-Mar-2022 06-Apr-2022 2.176e+07 {'OUD'} 2 {'7sadd0a7sd9a8sd9a8d0as8da'} 41 {'03/10/22'} 3/10/22 09-Mar-2022 06-Apr-2022 2.176e+07 {'OUD'} 3 {'7sadd0a7sd9a8sd9a8d0as8da'} 41 {'03/11/22'} 3/11/22

Más respuestas (0)

Categorías

Más información sobre Data Type Conversion en Help Center y File Exchange.

Etiquetas

Productos


Versión

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by