How to edit job_list using a date parameter
- Article Type: General
- Product: Aleph
- Product Version: 18.01
Desired Outcome Goal:
How can I put the parameters in the job list so that it will print from one date to another, where the date is always relevant to the current date (for example, from 8 days ago until yesterday)?
Procedure:
The job list has a way to enter days in parameters relevant to the current date.
For example:
%DATE+D007 means 7 days later than today.
%DATE-D006 means 6 days ago
see job_list header for more details.
Here are two examples from $alephe_tab/job_list, one which retrieves records created from 7 days ago until today, and another which retrieves records created from 8 days ago until 1 day ago
!* next line is p_ret_01 for records created from 7 days ago until today
01 08:29:00 Y USM01 p_ret_01 USM01,,7_ago_till_today,000000000,999999999
,,00,%DATE-D007,%DATE,00000000,99999999,,AND,,,,,,,,,00000000,99999999,
!*
!* next line is p_ret_01 for records created from 8 days ago until 1 day ago
01 08:29:00 Y USM01 p_ret_01 USM01,,8_ago_till_yesterday,000000000,99999
9999,,00,%DATE-D008,%DATE-D001,00000000,99999999,,AND,,,,,,,,,00000000,99999999,
Category: Background processing (500)
Subject: Batch (500)
- Article last edited: 10/8/2013