Brad, try clicking on the display window and scrolling up - perhaps the 11/10/04 entry is above the window. I have had some occasions where the display window rolls up even though I would not have expected it.
Speaking of rolling up, I set my display window to 1000 lines after a suggestion by someone else on this list. This is a great feature. --- Brad Davidson <[EMAIL PROTECTED]> wrote: > Hi Razzak, > > Interesting! Matching the date format settings suggested get the same > anomaly in select command for DESC order, only - ASC order returns all > values. > > Vstartdate = 11/01/2004 > Venddate = 11/30/2004 > Most recent date for prod_date is 11/10/2004. > > SELECT prod_date FROM produced WHERE + > prod_date BETWEEN .vstartdate AND .venddate ORDER BY prod_date DESC > > Descending query returns values for prod_date beginning with 11/09/2004, > omitting the 11/10/2004 entry. > > Ascending order correctly returns values 11/01/2004 through 11/10/2004. > > -Brad > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak > Memon > Sent: Thursday, November 11, 2004 8:23 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - RE: Scrolling Region Sort Order Descending Pblm > > > At 07:56 AM 11/11/2004 -0800, Brad Davidson wrote: > > >I've set default vstartdate and venddate is to current month: 11/1/04 and > >11/30/04. > > Brad, > > What happens when you SORT those dates using the simple > SELECT command at the R> prompt: > > Example: > > SELECT datecolumn FROM TableViewName WHERE ... + > ORDER BY datecolumn ASC > > OR > > SELECT datecolumn FROM TableViewName WHERE ... + > ORDER BY datecolumn DESC > > Does that command display the dates accordingly? > > On a side note, what are your database DATE FORMAT, > SEQUENCE, YEAR and CENTURY SETtings? > > Try the following settings and see what you get. > > DATE FORMAT: MM/DD/YYYY > DATE SEQUENCE: MMDDYY > Century Threshold YEAR: 30 > Default CENTURY: 19 > > Hope that helps! > > Very Best R:egards, > > Razzak. > > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
