Page 1 of 1

compare dates

PostPosted: Wed Apr 22, 2009 11:18 pm
by david lover
I am writing an racf icetool inactivity report. My question is there a way to compare dates. what i like to do is print out anyone that has not logon from today - 45 days.

icetool control statement:

 //RACFCNTL DD *                                                 
  SORT FIELDS=(19,10,CH,A,5,4,CH,A)                               
  INCLUDE COND=(5,4,CH,EQ,C'0200',AND,10,4,CH,EQ,C'IFXG',AND,     
               118,10,CH,LT,C'2009-04-01')                       
  OPTION VLSHRT                                                   


output should look like:

userid            username                last access date
xabxc             joe date                  2009-03-19


Hope this make sense.

david

Re: compare dates

PostPosted: Thu Apr 23, 2009 2:10 am
by Frank Yaeger
You can compare to today - 45 days using the following DFSORT condition:

  ...
  118,10,CH,LT,DATE1(-)-45)