[no subject]

[Ted Houghton <THoughto@UNITEDROAD.COM>]

Heather,
Have you tried adding an
order by b.end_dt
line?


-----Original Message-----
From: Heather Missel [mailto:hmissel@ROCHESTER.RR.COM]
Sent: Tuesday, May 30, 2000 9:28 PM
To: SQR-USERS@list.iex.net
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






*************************** N O T I C E **************************************

This message and any attachments is intended only for the individual or company 
to which it is addressed and may contain information which is privileged, 
confidential or prohibited from disclosure or unauthorized use. If the 
recipient of this transmission is not the intended recipient, or the employee 
or agent responsible for delivering such materials to the intended recipient, 
you are hereby notified that any use, any form of reproduction, dissemination, 
copying, disclosure, modification, distribution and/or publication of this 
e-mail message or its attachments other than by it's intended recipient is 
strictly prohibited by the sender. If you have received it in error, please 
notify us immediately and destroy the message and all copies in your possession.

This message has been scanned for viruses by Norton Antivirus.