fbpx
Select Page
Returns the day of the week as Sunday (1) to Saturday (7).

Usage

Weekday(<date Date>,<timezone Text>)

date (required) The date from which to return the weekday component.

timezone (optional) Name of IANA timezone to get the date part at, e.g. “America/Los_Angeles”. When calculating a timezone, input dates are treated as UTC.

NOTE: Sunday is 1 and Saturday is 7.

Examples

Weekday(Date(“2017-12-01”))
  • Returns 6

See Also

DatePart

More About Date Functions

Date functions are useful for analyzing date input and extracting individual time components, like year or minute, from date objects.

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.