Skip to main content
Question

How to handle "incomplete dates" with the DateTimeConverter ?

  • May 29, 2021
  • 1 reply
  • 23 views

ronmak
Contributor
Forum|alt.badge.img+5

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

hkingsbury
Celebrity
Forum|alt.badge.img+65
  • Celebrity
  • May 30, 2021

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