Crystal Reports How To — Convert String to DateTime

Crystal Reports How To — Convert String to DateTime

1. Create a formula.

2. In formula enter the following — Replace {TABLE.FIELD} with field to be converted.

If IsDateTime(left({TABLE.FIELD}, 10) + “ “ + mid({TABLE.FIELD},12,8))

Then

CDateTime(left({TABLE.FIELD}, 10) + “ “ + mid({TABLE.FIELD},12,8));