John McKown wrote on 03/24/2009 06:21:03 AM:
> I don't see a way to do this, but maybe I'm just missing it. I am writing
a
> report which read the RACF database unload report. The report basically
> shows IDs which have not been used in the last 90 days. This is rather
> simple with a statement similar to:
>
> INCLUDE COND=(USBD_LASTJOB_DATE,LE,DATE1(-)-90)
>
> This is replacing an existing report which printed the duration, which
would
> be something like (if it were possible):
>
> ON (DATE1(-)-USBD_LASTJOB_DATE) HEADING('INACTIVE DAYS')
>
> is there any way, using ICETOOL to subtract a date in YYYY-MM-DD,
character
> format, from today's date with the result being a simple number?
>
> I doubt it, but ...DFSORT/ICETOOL doesn't have any built-in function for calculating n = (Current_date) - (yyyy-mm-dd) Frank Yaeger - DFSORT Development Team (IBM) - [email protected] Specialties: FINDREP, WHEN=GROUP, DATASORT, ICETOOL, Symbols, Migration => DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort/ ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
