Skip to main content
  • EN

I am trying to format a source attribute that stores a date value as a single 4-character long year value (1995, 2000, 2005) to be in ISO date format (1995-01-01). However my DateFormatter transformer is only outputting values for the current date or for the default value when it encounters an invalid value (0001-01-01).

Any ideas? I'm lost. See below for pictures describing the problem.

Workbench & DateFormatter transformer

Original dates before being transformed

(The "YEAR" attribute is renamed to "utility_year_of_construction" in between here)

Dates after being transformed

The pictures aren't showing...
The pictures aren't showing...
I was able to copy and paste them into the submission box so I thought they could get uploaded automatically, but they didn't. I just hosted them on imgur and updated the post.

 

 

How about just using an AttributeCreator rather than the DateFormatter:

Didn't see any pictures, could you post them just to make sure I'm answering the right question :)

How about just using an AttributeCreator rather than the DateFormatter:

This seems to have fixed it but this is strange behaviour for the DateFormatter.

 

 

This seems to have fixed it but this is strange behaviour for the DateFormatter.

 

 

It would help if we could see the pictures...

Reply


Community Stats

30,189
Posts
114,582
Replies
37,853
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.