|
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
|