Date formatting for MSSQL

[John McDonald]

Would anyone be kind enough to point me in the right direction for a peice if code that will format dates, retrieved from an MSSQL database, into something readable. The problem here is that MSSQL only stores dates in (yy/mm/dd hh:mm:ss) format. I need to format that into mm/dd/yy and I search by this formatted date. I am in the midst of a project where I must use the MSSQL datetime type.   Anyone have any suggestions.    John D. McDonald CipherStream Systems Phone: 925.373.8700 Fax:     413.793.6603 email: [EMAIL PROTECTED] web: www.cipherstream.com ------------------------------------------------------- Secure E-Business Is Our Business -------------------------------------------------------