String to Date Conversion

[mytips]

Hi,
I have Date type fields in Oracle that changes to String type in Crystal automatically. I want Crystal to display these as Date Type(mm/dd/yyyy) format. The String type looks likes this in Crystal - 2001-09-14 13:56:25.00
Can someone please, help me find a way to display this in date type as mentioned above!!

 

[balves]

Create a formula on the field:

mid({table.field}, 6, 2) + "/" + mid({table.field}, 9, 2) + "/" + left({table.field}, 4)