Calculate the date difference
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Doaa Alamoudi
il 10 Ago 2020
Commentato: Star Strider
il 10 Ago 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 Commento
Walter Roberson
il 10 Ago 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.
Risposta accettata
Star Strider
il 10 Ago 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 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Startup and Shutdown in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!