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));