Converte Date

[andre]

I would like to use the node “string to date & time” to convert a date of format yyyy-mm-dd into the format dd-mm-yyyy. I get the following error: “Execute failed: Failed to parse date in row ‘Row0: Text’ 2018-12-17 'could not be parsed at index 2” Can someone give me a help?

[armingrudd]

Hi,

As I see, the date format you have selected doesn’t match your data. Click on “Guess data type and format” or choose yyyy-MM-dd as date format and there shouldn’t be any problem anymore.

Also I have found some topics similar to your issue. Maybe you’ll find them helpful:

Split different datetime string format with a regex

I have this 2 type of string format in a single table, here below an example: 11/08/1987 11-08-1987 Some of the row values have the “/” and some others have the “-” separation character. I would like to split them in 2 different tables in order to convert them as Date Time format. Why I need it? Cause if I process the entire table to a String to Date&Time node with dd/MM/yyyy format, then It thrown an error because I have also some rows values with different format string type (I mean with …

How to convert DATE format From dd-MMM-yy To yyyy-mm-dd ?

How to convert DATE format From   dd-MMM-yy    To   yyyy-mm-dd      ?

String to Date&Time Node Format MM.yyyy

Dear community, I have problems assigning a Date Format to my Date Column, which has the string format MM.yyyy -> e.g. 12.2017 However, the string to date&time node fails transforming it: ERROR String to Date&Time 0:615 Execute failed: Failed to parse date in row 'Row0#0: Text ‘12.2017’ could not be parsed: Unable to obtain LocalDate from TemporalAccessor: {MonthOfYear=12, Year=2017},ISO of type java.time.format.Parsed The settings were set like: [image] Someone encountered the same…

Best,
Armin

[mlauber71]

Put your scenario in a workflow. The Date manipulation is done with several KNIME nodes. One might also do that with a Java Snippet. With Date fields it is always the question how to store them, either as strings that can universally be stored and loaded or as UNIX timestamps or with the internal KNIME format. You always have to be careful. In a lot of Big Data storages the standard format for dates is:
yyyy-mm-dd a lot of programs can interpret that as a date format and even do calculations with it. Be sure to always check your results because date formats and operations can be notoriously tricky, even if you do not throw the whole localisation and timezone stuff at them.

kn_example_date_string_format.knwf (71.5 KB)

[andre]

Thanks for the workflow. I built this into my worklfow and created the date in the desired format.
Thank you very much.