Analyze Data for last complete Calendar week prior to current date

Question

Lambert Desa 2021-9-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1456974-analyze-data-for-last-complete-calendar-week-prior-to-current-date

评论： Lambert Desa 2021-10-1

I am at basic level in Coding with Matlab, will very much like my function to return the start and end-dates of the last full calendar week prior to today's date (full Calendar week from Sunday - Saturday). For example; if today is Monday, 20th Sep 2021, the function should return:

Start_Weekdate = '12-Sep-2021' and End_Weekdate = '18-Sep-2021'.

I unfortunately do not know how to define the appropriate Calendar Weekdate reference

function AnalyseWeekInterval(Home, START_Weekdate, END_Weekdate)

%prepare Tiem frame to analyse

START_Weekdate= datetime(FIRSTWEEKDAYDATE, 'TimeZone','local','InputFormat','dd-mmm-yyyy');

END_Weekdate= datetime(LASTWEEKDAYDATE, 'TimeZone','local','InputFormat','dd-mmm-yyyy');

end

I will appreciate your expertise on this.

Thanks in Advance

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Siddharth Bhutiya 2021-9-21

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1456974-analyze-data-for-last-complete-calendar-week-prior-to-current-date#answer_792314

在 MATLAB Online 中打开

There might be a couple of ways to do this, but the function that you are looking for is dateshift.

https://www.mathworks.com/help/matlab/ref/datetime.dateshift.html

>> dt = datetime(2021,9,20); % Our date of interest
>> End_Weekdate = dateshift(d,'dayofweek','Saturday','previous') % Get the date of the previous Saturday using dateshift
End_Weekdate = 
  datetime
   18-Sep-2021
>> Start_Weekdate = End_Weekdate - caldays(6) % Subtract 6 calendar days from it to get the date for the start of the week
Start_Weekdate = 
  datetime
   12-Sep-2021