Skip to main content
Version: Next

WeekStartDate

Given the input date, returns the date of the first day of the week. This function is equivalent to the expression DateAdd("d", -1 * (Weekday(Now(), 'vbSunday')-1), Now()).

Syntax​

WeekStartDate(Date, [vbWeekStartDayConst])

Parameters​

Date
The date to use for the calculation.

vbWeekStartDayConst
Optional. String constant indicating the first day of the week (Sunday, Monday, and so on). This parameter supports the following values:

  • vbUseSystem
  • vbSunday
  • vbMonday
  • vbTuesday
  • vbWednesday
  • vbThursday
  • vbFriday
  • vbSaturday

If no value is provided, this parameter defaults to vbSunday.

Example​

The following expression returns the week start date for 2008-06-09:

[DateCustom].[StandardWeek].[Week].&[`WeekStartDate("2008-06-09T12:30:10", "vbSunday")`]