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

Syntax:

BOY(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:

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

Note:

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

See also:

BOM, EOM, EOY, AddDate,CDOW, Date

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

The Online and Rich Client Samples projects (program DT09 and RDT09)