I have been given a database dump (thousands of rows) that put the dates in a
text format like this:

Aug/11/2009

Is there any way to put this into a date format? Even if it means creating a
new field breaking it up and doing some extra steps.

Thanks.