Function

Description

Set or returns a function for the QueryFieldDef . The DbFunction enum identifies the function for the field.

The following date functions are currently supported. These DbFunctions apply to fields of type _DATE_TIME (that is, they can only be applied to datetime fields).

For example, given the submit date of 8/29/2002, you get the following values for the DbFunctions:

• year: 1/1/2002 //the date that is the first of the year
• week: 35,2002 //the 35th week of year 2002 separated with a comma
• month: 8/1/2002 //the first of the month
• day: 8/29/2002 //the day itself

Syntax

VBScript

queryfielddef.Function 
queryfielddef.Function NewValue 

Perl

$queryfielddef->GetFunction();
$queryfielddef->SetFunction(NewValue); 

Identifier

Description

queryfielddef

A QueryFieldDef object.

NewValue

A Long that specifies the function type for the field. The value corresponds to one of the DbFunction constants.

Return value

Returns a Long that identifies the function type for the field. The value corresponds to one of the DbFunction constants.