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 which 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

Last updated
Was this helpful?