### Aged0To30Days, Aged31To60Days, Aged61To90Days

Basic and Crystal syntax.

##### Returns

None

##### Action

Specifies a range of Date values that fall within a certain time period before the present date. If the current date is 12/30/98, Aged0To30Days specifies the period from 12/1/98 to the present date, Aged31To60Days specifies the period from 11/1/98 to 11/30/98, and Aged61To90Days specifies the period 10/2/98 to 10/31/98.

##### Examples

The following examples are applicable to Crystal syntax:

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

Returns the Amount if the date falls within the previous 30 days from today's date. 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 | 03/10/98 | 0
first date included | 03/11/98 | 1252.24
| 03/15/98 | 1597.87
| 04/05/98 | 2546.35
last date included | 04/10/98 | 5462.21

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

Returns the Amount if the date falls within the previous 31 to 60 days from today's date. 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 | 02/08/98 | 0
first date included | 02/09/98 | 1252.24
| 02/25/98 | 1597.87
| 03/05/98 | 2546.35
last date included | 03/10/98 | 5462.21

Note: If you would like to base the date range on a date other than today's date, you must either change the date via the Date/Time option in the Windows Control Panel, or change the report print date via the Set Print Date/Time command in the Report Menu.

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