Function: Qtr

Description

Indicates which quarter of the year a date falls within: 1=January-March, 2=April-June, 3=July-September and 4=October-December.

Syntax

Qtr(date)

Arguments

date can be a constant, a date field, an expression that results in a date or a function that returns a date.

Return value

This function returns a number in the range 1-4.

Calculated field example

If the Ship_date field contained the value 20010915, the following calculated field expression would return the value 3 (indicating that the 9th month of the year falls in the 3rd quarter): Qtr(Ship_date)

Filter/Find example

Records with Ship_date values which fall in the first half of the year -- such as 20010401, 19990215 or 19940629 -- can be selected or found using the expression: Qtr(Ship_date)=1.Or.Qtr(Ship_date)=2