Selecting Mondays from a Timetable or Table using the datetime object

Hi,

I would like to write a script that scrolls through my five minutes resolved timetable / table to select identifies all the days that are Mondays and then group them based on the datetime variable of the table/timetable.

I have tried several other ways to do it including the one below. Instead, if I specify the the day as 1, it returns all the first days of the periods (in this case months) and not specifically the Mondays.

Day1=HHB1(1==day(HHB1.VarName1),:); % HHB1 is the datetime object

%%

Any help?

Answer 1

[Stephen23]

By default DAY returns the day of the month, so you need to specify its second argument like this:

d = day(t,'dayofweek')

[Lewis Waswa]

Thank you for the response @Stephen. However, the I still cannot subscript the dat set to get the day type I need. For instance, if I specify the following

Day1=HHB1(day(HHB1.VarName1,'dayofweek'),:);

The Day1 output is the same as the original dataset HHB1 with a single timestamp for all the entries. How would you recommend one moves from here

[Stephen23]

idx = day(HHB1.VarName1,'dayofweek')==7;
out = HHB1(idx,:);

Unfortunately MATLAB does not use the international standard of Monday==1: https://en.wikipedia.org/wiki/ISO_8601

Squeezing everything onto one line is not required and does not make the code more efficient. Clarity is better.

[Lewis Waswa]

Thank you @Stephen. This returns the data I need.

[Stephen23]

@Lewis Waswa: Please remember to click the accept button if my answer helped you.