Download ACL for Windows Version 7 Workbook

Transcript
Module 4
Manipulating Data
Aging Data
161
Using the AGE( ) Function
The AGE( ) function calculates the number of days between two dates you specify. If you
do not specify a second date, ACL selects the current system date. For example, you can
use AGE( ) to compare a receivable transaction date to a year end date in order to
determine account ages at year-end.
The dates you enter may be in the format of a character string, in the format YYMMDD
or YYYYMMDD, or a valid ACL date field in any format.
Dates older than the cutoff date return a positive value, whereas dates more recent than
the cutoff date return a negative value.
In this exercise, you extract the customer number, transaction amount, and invoice date
for all items aged more than 180 days, as of the fiscal year ended December 31, 2000.
▼
To use the AGE( ) function to perform the described task:
1. If you have closed the Workbook file, open the Workbook.acl file and drag the Ar
default view from the Overview window.
2. Click
(Extract) or select Data from the menu bar and choose Extract. The
Extract dialog box opens.
3. Select Fields to make the Extract Fields list view available.
4. Select the No field; hold down CTRL and select the Amount and Due fields as well.