Try this:
DT = (datetime([2017 01 01]):caldays(1):datetime([2020 01 01])).'; % Create Dates
HP = ones(size(DT)); % Create ‘HP’
TT = timetable(DT,HP); % Create ‘timetable’
TF = [(TT.DT(day(TT.DT)==1 & month(TT.DT)==5)) (TT.DT(day(TT.DT)==30 & month(TT.DT)==9))]; % Starting & Ending Dates For All Years
for k = 1:size(TF,1)
TT.HP(TF(k,1) : TF(k,2),:) = 0; % Loop Through Years
end
Check = [TT(115:125,:); TT(270:280,:)]; % Check That It Works! (Delete Later)
CheckPlus1Yr = [TT((115:125)+365,:); TT((270:280)+365,:)]; % Check That It Works! (Delete Later)
Use the ‘TF’ matrix and the loop with your own timetable.
I called my datetime variable ‘DT’ to avoid using ‘datetime’ as a variable name.
The ‘Check’ lines show parts of the timetable demonstrating that this approach works. They are not otherwise a necessary part of the code, so delete them later.
