BOMONTH

Returns the first day of the month for a given date (Beginning Of MONTH)

Usage

BOMONTH(date)

Parameters

date

(Required) The date from which to determine the beginning of the month

Examples

Example With these variables Result

BOMONTH(current_date)

current_date is DATE(2024, 1, 12)

DATE(2024, 1, 1)

BOMONTH(DATE(2023, 2, 15))

(None)

DATE(2023, 2, 1)

More information

The function returns the first day of the month for the given end_date.

The name comes from “Beginning Of MONTH”.

Reminders

A text containing a date is not handled as a date. To have an actual date:

  • use the @DATE_QUESTION to set the variable
  • use a function that converts to a date: DATEVALUE(text_date)
  • use a function that returns a date: TODAY() or DATE(year, month, day)

See also