Date.StartOfWeek
Date.StartOfWeek(dateTime as any, optional firstDayOfWeek as nullable number) as any
Returns the start of the week that contains dateTime
. dateTime
must be a date
, datetime
, or datetimezone
value.
Find the start of the week for Tuesday, October 11th, 2011.
Usage
Date.StartOfWeek(#datetime(2011, 10, 11, 8, 10, 32))
Output
// Sunday, October 9th, 2011
#datetime(2011, 10, 9, 0, 0, 0)
Find the start of the week for Tuesday, October 11th, 2011, using Monday as the start of the week.
Usage
Date.StartOfWeek(#datetime(2011, 10, 11, 8, 10, 32), Day.Monday)
Output
// Monday, October 10th, 2011
#datetime(2011, 10, 10, 0, 0, 0)