Convert String to Date

I have the following format in a property of a database I'm working with:

Tue Aug 19 00:00:00 2008

Obviously, this is suppose to be a date format.  However, due to reasons beyond my control this is a string, and I cannot change it within the datebase to a date format.  Any ideas on how to convert this string to an actual date format within Pipeline Pilot?

Thanks,

Jeff