Search found 3 matches
- Thu Sep 10, 2015 11:48 am
- Forum: SyncSort, SyncTool, SyncGener.
- Topic: SORT records on date.
- Replies: 7
- Views: 3521
Re: SORT records on date.
You'll need to PARSE the fields in INREC, then make a temporary extension to the record. Heed Robert's point about sorting in a logical order (year, month, day). In OUTREC, use BUILD to return the record to its original size. Thanks but what are you saying when you say "a temporary extension t...
- Thu Sep 10, 2015 11:47 am
- Forum: SyncSort, SyncTool, SyncGener.
- Topic: SORT records on date.
- Replies: 7
- Views: 3521
Re: SORT records on date.
Dates are in DD.MM.YYYY format.Robert Sample wrote:What format are the dates in? You cannot put together a SORT statement without knowing that. Whatever the format, you'll want to sort by year, month, day to get the data in ascending date sequence.
- Wed Sep 09, 2015 9:40 pm
- Forum: SyncSort, SyncTool, SyncGener.
- Topic: SORT records on date.
- Replies: 7
- Views: 3521
SORT records on date.
Hi, I need to sort the records in a dataset based on date in ascending order. If there are three dates namely 31.1.1998, 2.12.1997,3.6.2014 then output should have 2.12.1997,31.1.1998,3.6.2014 I have used the sort card: SORT FIELDS =(60,10,UFF,A) But the records are not getting sorted properly. Can ...