Hi Kolosu, So simple, and I was not seeing it. Thank you very much for you help Best wishes JAck
On Fri, 14 Apr 2023 at 17:33, Sri h Kolusu <[email protected]> wrote: > >> 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 > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
