>> Using this file as input, I need to create one with only the records for
>> which the LRDATE are is equal to today's date less one year.
Jake,
Your LRDATE has the separator as Slash "/" but you are using hyphen "-' as a
separator. So, you need to change that. Secondly you are using Less than or
Equal (LE) as relational operation. So Current date- 365 would end up as
2022/04/14 (assuming the current date is 2023/04/14). So, any record less
than that date would be included. Is that your intention?
Here is the modified include condition and changed the relational condition to
EQ.
INCLUDE COND=(KBTYPE,EQ,C'K',AND,
LRDATE,CH,EQ,DATE1(/)-365)
Thanks,
Kolusu
DFSORT Development
IBM Corporation
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
