Returns the date of the beginning of the month specified in the parameter.

Syntax:

BOM(date)

Parameters:

date: any Date variable, a hard-coded date, such as '05/06/2008'DATE, or an expression that evaluates to a date

Returns:

Value of type DATE

Example:

BOM ('05/10/93'DATE) returns '05/01/93'

Note:

One use for this function is to set the date range for reports.

See also:

BOY, EOM, EOY, AddDate,CDOW, and all Date functions.

How Do I Calculate the Beginning of the Month of a Given Date?

The Online and Rich Client Samples projects (program DT08 and RDT08)