Reported By: Stephen Ebbrell Reported On: 2/16/1999 For: Version 1.11 Build 1
# 304DESCENDING 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....
CommentsThe 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.
ResolutionFixed Problem on 2/16/1999 in version 1.12 build 1