Search found 3 matches

by SarvanaL
Thu Sep 10, 2015 11:48 am
Forum: SyncSort, SyncTool, SyncGener.
Topic: SORT records on date.
Replies: 7
Views: 3245

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...
by SarvanaL
Thu Sep 10, 2015 11:47 am
Forum: SyncSort, SyncTool, SyncGener.
Topic: SORT records on date.
Replies: 7
Views: 3245

Re: SORT records on date.

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.
Dates are in DD.MM.YYYY format.
by SarvanaL
Wed Sep 09, 2015 9:40 pm
Forum: SyncSort, SyncTool, SyncGener.
Topic: SORT records on date.
Replies: 7
Views: 3245

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 ...

Go to advanced search