Flexible Date Reader

A flexible date reader.

This component will attempt to read dates in a variety of free-text formats. The only requirement is that the Day Month and Year order of the received dates is known.

At the moment, this handles months written in ENGLISH only. It would be nice to internationalise this, and I will look at doing that. If you interested in helping with that (even if just for developing/testing with one other language, please contact me on the KNIME forum by posting a message in the Extensions area - @takbb)

i.e. It cannot possible "know" if 01-02-2022 is 2 Jan or 1 Feb (and neither can you unless you "know" your data), so you do have to tell it this part.

Other than that, throw some dates at it which

e.g configure it to month-day-year and then try it with

Feb-01 2022
02-01-2022
02/01/2022
Feb 1st 2022
February 1 2022

You get the idea!

Enjoy

@takbb 24 September 2022

Input ports

1. Type: Table
   Data
   Data containing a String field containing dates in "free format"

Output ports

1. Type: Table
   Converted Dates
   The original data plus a Date field containing the interpreted dates, based on the date field sequence chosen.