Re: DFSORT and date YYYY/MM/DD

2023-04-14 Thread Paul Gilmartin
On Fri, 14 Apr 2023 17:10:31 +0100, Jack Zukt wrote: > >I have file produced by FDREPORT with this format: >... >0PRODSN1.ZOS.MLQAAA01.SAAA0001.D230320.T0541 TP0070 PACTD01 2015/07/21 >2025/08/21 57K > ... -- gil -

Re: DFSORT and date YYYY/MM/DD

2023-04-14 Thread Jack Zukt
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 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. > > Jak

Re: DFSORT and date YYYY/MM/DD

2023-04-14 Thread Sri h Kolusu
>> 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 th

DFSORT and date YYYY/MM/DD

2023-04-14 Thread Jack Zukt
Hi, I have file produced by FDREPORT with this format: 1FDR400FDRABR CUSTOM REPORTS - FDREPORT VER 5.4/90P INNOVATION DATA PROCESSINGDATE - 0 DATA SET NAMEVOLSER CREATJOB CRDATE LRDATE FILE SIZE ---