endofweek()

适用于：✅Azure 数据资源管理器✅Azure Monitor✅Microsoft Sentinel

提供包含日期的周末，如果提供，则按偏移量移动。

一周的最后一天被视为周六。

Syntax

endofweek( date [, offset])

Learn more about syntax conventions.

Parameters

Returns

Returns datetime representing the end of the week for the given date value, with the offset, if specified.

Examples

以下示例返回指定日期的周结束时间。

  range offset from -1 to 1 step 1
 | project weekEnd = endofweek(datetime(2017-01-01 10:10:17), offset)  

Output

以下示例将周末作为指定日期的星期日返回。

let endofweekSunday = (dateArg: datetime) {
    datetime_add('day', 8, endofweek(datetime_add('day', -8, dateArg)))
};
let data=datatable(Date: datetime, day: string)
[
datetime(2025, 6, 14), "Saturday",
datetime(2025, 6, 15), "Sunday",
datetime(2025, 6, 16), "Monday",
datetime(2025, 6, 17), "Tuesday"
];
data 
| extend SundayEndOfWeek=endofweekSunday(Date)

Output

Related content

• startofweek function
• endofday function
• endofmonth function
• endofyear function
• dayofweek function
• week_of_year function
• ago function