I have columns with the following char format:

06/01/2007 12:00


I want to convert this to 06/01/2007 so it can be used in a calculation.

How do I do this?