How do I convert dates to days?
Show older comments
Let us say I have a series of dates: '01-01-2022', '05-01-2022', '06-01-2022' and I have corresponding data on these dates how do i convert the dates to an array that looks like this: [0,4,5]
Generally something like this:
Accepted Answer
More Answers (2)
Your example and explanation are inconsistent: your explanation shows difference between adjacent dates, your example vector shows differences to the first date. Here are both:
C = {'01-01-2022', '05-01-2022', '06-01-2022'};
T = datetime(C,'inputFormat','d-M-u');
V = days(T-T(1)) % what your example shows
D = [0,caldays(caldiff(T))] % what you explained
KSSV
on 18 Mar 2022
0 votes
Read about datevec. This will give you respective days from the dates.
3 Comments
Hamza Yusuf
on 18 Mar 2022
DateString = {'09/16/2007';'05/14/1996';'11/29/2010'};
formatIn = 'mm/dd/yyyy';
[y,m,d,H,M,S] = datevec(DateString,formatIn);
d
Hamza Yusuf
on 18 Mar 2022
Categories
Find more on Dates and Time 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!