Question

How to handle "incomplete dates" with the DateTimeConverter ?

  • 29 May 2021
  • 1 reply
  • 1 view

I am running data through a workspace that has several date fields.  In most cases the source text string convert fine, but there are many entries where the specific date was not known so only the year was recorded.  An example is below.  How do I handle this?  I would prefer not to make them all January 1 or any other arbitrary date in the year specified.

04-12-1964
25-02-1999
1952
14-06-1954

 


1 reply

Userlevel 5
Badge +29

If you set "Passthrough nulls, empties, or missing" to "Yes" then this will ignore those that don't match and pass them through unchanged

Reply