I need to omit records from input file where the date is older than 180 days. The date is in "MM/DD/YY" format. I understand that I could have used Y2W operand in OMIT COND clause had the date been of six character. In other words without "/" separators.
Can someone please provide a pointer to OMIT records based on the DATE value in "MM/DD/YY" format.
Following is the JCL I tried. I got the Syntax error in OMIT Clause. On removing the "(/)" after the "DATE1 parameter - The error changed to "INCLUDE/OMIT INVALID LENGTH"
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
manoopatil,
Check out the below example. I have modified the data to have some output records, as Current date - 180 days = 08/30/2008. Also Note the CENTWIN parameter which specifies the century window 1950-2049. You can modify it as per your requirement.