- In your BIRT data set, ensure that you're selecting the TDW Timestamp that needs to be converted to the regular timestamp.
- In the "Edit DataSet Window", click on Computed Columns and Click New button.
- Give the column name for the new Computed Column, select the column data type as "Date Time".
if (row["Timestamp"] == null)
parseInt(candleTime.substr(0,3))) + "/" +
+ "/" + candleTime.substr(5,2) + " " +
":" + candleTime.substr(9,2) + ":" +
5. Goto the Preview Results and ensure that the newly Computed Column appears in the output.
This is the kind of method that ITM 6.2 built-in reports use and hope you find it useful.