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.
