Heather, Can't you use Select to_char(b.end_dt, 'YYYY/MM/DD')? Also, your statement with to_date(to_char(b.end_dt, 'MM/DD/YYYY)) is missing the closing ' - not sure if this is how you actually have it in your code. Judith Heather Missel <hmissel@ROCHESTER.RR.COM> on 05/30/2000 09:28:07 PM Please respond to sqr-users@list.iex.net To: SQR-USERS@list.iex.net cc: (bcc: Judith Cruz-Lancaon/CORPHQ/NYTIMES) Subject: I am having a problem building a list box that contains calendar end dates in the correct order. I build the SQL view as: Select to_char(b.end_dt, 'MM/DD/YYYY') !Need this format from ps_deptid_tbl The returned values are in alpha order, and I need them in date order. I have also tried to_date(to_char(b.end_dt, 'MM/DD/YYYY)) from ps_deptid_tbl This returns a SQL error "not a valid month" Any help would be greatly appreciated Dennis
|
I am having a problem building a list box that
contains calendar end dates in the correct order.
I build the SQL view as:
Select to_char(b.end_dt, 'MM/DD/YYYY')
!Need this format
from ps_deptid_tbl
The returned values are in alpha order, and I need
them in date order.
I have also tried to_date(to_char(b.end_dt,
'MM/DD/YYYY))
from ps_deptid_tbl
This returns a SQL error "not a valid
month"
Any help would be greatly appreciated
Dennis
|