User Tools

Site Tools


syntax:functions:weekstart

WeekStart(date)

Category: Date and Time function


Description

This function returns the date serial number of the first day (Sunday) of the week date falls in.


Arguments

ArgumentTypeDescription
dateDate or Number (date serial)An expression representing a date to derive the Sunday date value from.

Return value type: Date serial number


Remarks

The date argument can take any value or expression that evaluates to a date serial value. Examples include:

  • A date string: #2019-12-12
  • A date serial value: 43811 (the date serial for "2019-12-12")
  • A date value created using any of the Date/Time functions that returns a date serial value.


Examples

weekstart(#2018-06-06)  //Returns 43254 (Equivalent to Sun, June 3th, 2018.)
weekstart(30970)  //Returns 30969 (Equivalent to Sat, October, 14th, 1984.)


See also

syntax/functions/weekstart.txt · Last modified: 2021/09/09 16:38 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki