Crystal Reports How To — Convert SQL Time to Clarion Time

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}