DateTime Column is recognised as string in BIRT
Dear community.
I have several DateTime columns in my KNIME dataset. Unfortunately, once I feed my dataset into BIRT using the 'Data to Report (BIRT)" node, all the DateTime columns become string and I cannot really use them properly anymore.
Is there a way to make BIRT recognise the DateTime columns from KNIME?
What I want to achieve in the end is to use the formatter in BIRT (e.g.
Formatter.format(row[“timestamp”], “yyyy-MM-dd”) ) to format my DateTime field, so that I see something more readable than “2024-09-04T08:17:44.881094”.