String Field to Date in 8.5

[prl423]

I have the following string field (that is a user defined field) and is inputted to the program as 06/23/97

I need to convert this string field to a date field in CR 8.5 this is the format in the db

+000019970623000000 any help on how the formula should be, as I keep getting an error that says non-numeric.

thanks

 

[eriktoronto]

I just tried this and I think this should work for you ({string_field} would be the user defined field you are using with a the date value):

DateValue(ToNumber({string_field}[5 to 8]),ToNumber({string_field}[9 to 10]),ToNumber({string_field}[11 to 12]))