Crystal Reports How To — Convert SQL Time to Clarion Time

Peter Musu`
1 min readAug 6, 2020

--

Crystal Reports How To — Convert SQL Time to Clarion Time

Steps:

1) Create Formula in Crystal Reports and provide a name e.g. ‘ChangedAt’

2) In the formula add the following:

time(TONUMBER(({Command.EDITEDAT}))/86400/100)

Replace {Command.EDITEDAT} with {table.field}

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