Hi Kolusu That solved this problem. Thank you very much for your assistance Best wishes Jack
On Thu, 21 Jul 2022 at 19:10, Sri h Kolusu <[email protected]> wrote: > >>If I use 117,4,CH,LE,X'2021202F', it works as expected. But I do not > want to have a hard coded date. I have used on a different report > "118,10,BI,LE,DATE1(-)-90)" for dates with the "yyyy-mm-dd" format. > >>My interpretation of the DFSORT manual for a date on the "yyyyddd" > format, is that I should use the DATE3 symbol, but it is not working. I > will keep reading the manual and I will keep trying on but, in the > meantime, does anyone has a suggestion? > > Jack, > > You need to use DATE3P which is a packed decimal format in +yyyyddd format. > > So you can use > > INCLUDE COND=(009,2,CH,EQ,C'D ',AND, > 117,4,PD,LE,DATE3P-90) > > This will filter out the records that have last reference date <= current > date - 90 days > > Further if you have any questions please let me know > > > 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
