Calculation Formulas

Back to Calculation Formulas Overview
Back to Functions Overview

Function "ThisWeekStartMillis"

ThisWeekStartMillis(firstDayOfWeek, timezone)

Function: Determines the timestamp of the start of the current week, i.e. 00:00h (in the given timezone) of the first day of the current week, represented in milliseconds since "Jan. 1st 1970, 00:00:00 GMT".

Return-Type: Number

Arguments:
firstDayOfWeek - Type Text: The name of the first day of the week. Must be either "Sunday" or "Monday" (lower/uppercase irrelevant).
timezone - Type Text: The ID or value of the timezone that shall be used to determine the 00:00h time of the first day of the current week. See here for possible timezone values.

Example:
ThisWeekStartMillis("Monday", "CET")
(determines the timestamp that represents 00:00h of the first day of the current week, where the week is supposed to start on a monday, relative to Central European Time)