Y2K sort issue (AREV Specific)
At 24 MAY 1999 04:49:30PM John Grey wrote:
I read that Arev will sort date fields incorrectly if they are defined as D2- instead of D4-.
For example,11324 (1/1/99) would come before 11689 (1/1/00) when running a sort on the field (where the data is stored in Arev internal format).
I support a 1.16 system and cannot replicate this.
If I sort by Y1, the results are correct
Key…………….. Y1……
3 08-21-92
2 02-11-98
1 11-07-00
where the Y1 field contains
Key…………….. FIELD 1
3 9000
2 11000
1 12000
I am trying to avoid redefining from D2- to D4-.
Has anyone run inot this?
Thanks
At 24 MAY 1999 05:55PM Richard Wilson wrote:
Looks like your justification is L not R
if this is the case then you should have had
a problem back on day 10000
At 24 MAY 1999 07:19PM Warren wrote:
RList date sorts are done on the internal (integer) representation and as long as the field is right justified should sort correctly.