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
© 2024 Altair Engineering Inc. All Rights Reserved.