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.
Related documents
HP NW280AAABA User's Manual
HP Prime Graphing Calculator User Guide
Calculatrice graphique HP Prime Manuel de l - Calculatrices-hp
ProStart Main Menu - American Top Tools
QuickBooks Link
Xinorbis4.2 User Manual
Access 2007-Manual - Human Resources | Maricopa Community
HP Prime Graph-Taschenrechner Bedienungsanleitung
Modicon Hand-held Programmer User`s Manual
PowerFlex 20-750-PNET2P Profinet Dual
My CloudMirror Personal Storage Drive User Manual
RM0038 Reference manual