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}