Calculation Formulas

Back to Calculation Formulas Overview
Back to Functions Overview

Function "ThisMonthStartMillis"

ThisMonthStartMillis(timezone)

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

Return-Type: Number

Arguments:
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 month. See here for possible timezone values.

Example:
ThisMonthStartMillis("CET")
(determines the timestamp that represents 00:00h of the first day of the current month, relative to Central European Time)