Hi, I have this field "status_created_at which is a string:
I need to convert to a date or extract only the YYYY-MM-DD but I cannot with extract date to string node and string to date node…
How can I do that?
In this field I note there is a strange text T between date and time…
Can you help me please?
Hi there @giad,
you can also use String Manipulation node with substr() function to get only first 10 characters from your column. Or you can convert String column to Date&Time column using String to Date&Time node followed by Modify Time node with option Remove time.
“T” is part of KNIME Date&Time column type. Probably you had this column as Date&Time type and somehow converted into String which left “T” between Date and Time parts…
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.