Crystal Reports How To — Convert SQL Date to Clarion Date

Crystal Reports How To — Convert SQL Date to Clarion Date

Steps:

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

2) In the formula add the following:

cdate({Command.EDITEDON}-36161)

Replace: {Command.EDITEDON} with {table.field}