|
View previous topic :: View next topic
|
| Author |
Message |
ami777us
New User
Joined: 06 Apr 2007
Posts: 33
Location: USA
|
|
|
|
Hi,
I have a gregorian format date in an input file.
I want to include only those records where the date field in the input file is Less than or equal to CURRENT DATE. Please let me know if it is possible in syncsort alone. |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
| Back to top |
|
|
ami777us
New User
Joined: 06 Apr 2007
Posts: 33
Location: USA
|
|
|
|
The date format in the file is YYYY-MM-DD.
I used the sort card (1,10,CH,LE,DATE1).
This is working fine.
Thank You. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Good to hear it is working - thanks for letting us know 
d |
|
| Back to top |
|
|
|
|
