Calculate the date difference
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Doaa Alamoudi
el 10 de Ag. de 2020
Comentada: Star Strider
el 10 de Ag. de 2020
I have two columns StartDate and Endate the value of the columns is 'datetime'
EndDate=[ '05-Aug-2020 00:00:00'
'05-Aug-2020 00:00:00'
'07-Aug-2020 00:00:00'
'07-Aug-2020 00:00:00'
'07-Aug-2020 00:00:00'
'01-Aug-2020 00:00:00']
Start Date= ['29-Jul-2020 00:00:00'
'29-Jul-2020 00:00:00'
'31-Jul-2020 00:00:00'
'31-Jul-2020 00:00:00'
'02-Aug-2020 00:00:00'
'01-Aug-2020 00:00:00'
'02-Aug-2020 00:00:00'
'29-Jul-2020 00:00:00'
'29-Jul-2020 00:00:00']
I would like to calculate the number of days per row in the column.
1 comentario
Walter Roberson
el 10 de Ag. de 2020
The number of day between what and what?
You appear to have a different number of EndDate than StartDate so a simple subtraction and calling days() does not appear to be what you would want to do.
Respuesta aceptada
Star Strider
el 10 de Ag. de 2020
The vectors must have the same sizes.
DaysDiff = between(StartDate(1:numel(EndDate)),EndDate)
to get:
DaysDiff =
6×1 calendarDuration array
7d
7d
7d
7d
5d
0d
.
2 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Startup and Shutdown en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!