Bom()

<< Click to Display Table of Contents >>

Navigation:  Available Functions >

Bom()

Syntax

Bom( <DateValue>)

 

Purpose

To determine the first day of the month for any date.

 

Parameters

<DateValue> is the date to determine the first day of. If this parameter is omitted, the system date is used (the system date is the same date returned by the Date() function).

 

Returns

A date value.

 

Usage

Bom() allows you to determine the first day of the month that contains <DateValue>. This would, for example, allow you to determine how many days have passed since the beginning of the month.

 

Example

The following examples illustrate BOM():

 

CALL

RESULT

Date()

02/25/2017

Bom( Date() )

02/01/2017

Date() - Bom( Date() )

24