Thank you very much for your help. Wraping the COALESCE in a COVERT function worked perfectly.

Doug

I wish I could format dates as you suggest, but I built the database of 15.5 million records from monthly extracts from an InfoLease database to give installation and installed...

Thank you for your question, I wanted to use the coalesce functionin a SQL Server View to give me an installation date where the date can come from one of...

Thank you very much for your help. Wraping the COALESCE in a COVERT function worked perfectly.

Doug

Thank you very much for your help. Wraping the COALESCE in a COVERT function worked perfectly.

Doug