### Calendar1stHalf, Calendar2ndHalf

Basic and Crystal syntax.

##### Returns

None

##### Action

Specifies a range of Date values that includes all dates that fall within the first or second half of the calendar year, respectively. The first half of the calendar year includes all dates from January 1st through June 30th. The second half of the calendar year includes all dates from July 1st through December 31st.

##### Examples

The following examples are applicable to Crystal syntax:

If {orders.ORDER DATE} in Calendar1stHalf Then
{orders.ORDER AMOUNT}
Else
0

Returns the Amount if the date falls on any date in the 1st half of the calendar year. The following table identifies the first and last dates included in the date range if today equals 04/10/98.

If today = 04/10/98 | {orders.ORDER DATE} | {orders.ORDER AMOUNT}
not in range | 12/10/97 | 0
first date included | 01/01/98 | 1252.24
| 03/05/98 | 1597.87
| 05/15/98 | 2546.35
last date included | 06/30/98 | 5462.21

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com