Icon View Incident Report

Serious Serious
Reported By: Stephen Ebbrell
Reported On: 2/16/1999
For: Version 1.11 Build 1
# 304 DESCENDING Keyword for ORDER BY Clause Is Not Working Properly For Dates

I'm using D3 as you probably know, the trouble I am having using DBISAMQuery is sorting Dates correctly. If I use ORDER BY datefield the dates come out with some years data in the wrong position as if it is being ordered by the string value of the date. Is there a way of Ordering a Datefield so that the order is correct. I am looking for something like ORDER BY datefield AS DATE I think....


Comments Comments
The problem was due to the descending logic that flipped the field values into reverse order. This problem only occurred on non-string fields such as dates, integers, etc.


Resolution Resolution
Fixed Problem on 2/16/1999 in version 1.12 build 1
Image