To convert a character date into Date format, you can use the following: In the Report designer, create a 'New Calculated Item' and use the Parse operator(under simple text). For example, Parse('Joining_date', 'DATE9.') returns a date value where 'Joining_date' is my Date column name and 'DATE9.' is the date format.
... View more