SOWEEK

The SOWEEK function takes the date as input and returns the starting date of the week. Node references and measures are also accepted as input arguments. Use DATE.SET() to set the format of the output date.

Syntax

SOWEEK(date)

Arguments

date - The date that is passed as an input to the function. Required.

Return value

Date representing the start of the week.

Example

SOWEEK("05/29/2024")
//Returns 27/5/2024

Starting of the week