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.
