<< 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 |