I have a file with high vol. of Data. There is a Date Field also. There are 2 requirements.
1) I need to select all records which are less than CURRENT DATE.
2) Need to Select all records where Date >= CURRENT DATE + 63 Days.
All Extracted records to be written to a seperate file. O/P file have same attribute as Input file.
Date is in Format YYYY-MM-DD.