How to convert varchar field to date format in crystal reports?

Question

I have a field 'DOB' where it is of type varchar in mysql.I get output in the format of 1989/09/24 00:00:00.000 when i select the statement.I get the same in crystal reports.I need to convert it into format of sep 09,1989.I am not finding how to do it in the formula editor.help me out regarding this.thanks...

Answer 1

Try this, which first takes the varchar and removes the space and the time stamp after the date and then coverts what is left to an actual date. Once that is done you can format the field anyway that Crystal allows.

CDate(Left({YourDateField}, Instr(1, {YourDateField}, " ") - 1))

Just replace the YourDateField with the field you are trying to convert.