Skip to main content
  • EN

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

 

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


Community Stats

30,166
Posts
114,513
Replies
37,821
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.