Crystal Reports How To — Convert String to DateTime

Peter Musu`
1 min readAug 5, 2020

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

Sign up to discover human stories that deepen your understanding of the world.

Free

Distraction-free reading. No ads.

Organize your knowledge with lists and highlights.

Tell your story. Find your audience.

Membership

Read member-only stories

Support writers you read most

Earn money for your writing

Listen to audio narrations

Read offline with the Medium app

No responses yet

Write a response